azure-docs/articles/backup/backup-azure-database-postgresql-server-faq.yml at 4d3b7d4d94d833ea8fb02f12761d5000412c7ef4 · MicrosoftDocs/azure-docs · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
### YamlMime:FAQ
metadata:
  title: FAQ - Backing up Azure Database for PostgreSQL server
  description: In this article, discover answers to common questions about backing up Azure Database for PostgreSQL server with the Azure Backup service.
  ms.topic: faq
  ms.service: azure-backup
  ms.date: 03/18/2025
  ms.update-cycle: 1095-days
  author: AbhishekMallick-MS
  ms.author: v-mallicka

title: Frequently asked questions-Back up Azure Database for PostgreSQL server
summary: |
  This article answers common questions about backing up Azure Database for PostgreSQL server with the [Azure Backup](./backup-overview.md) service.

  >[!Important]
  >Azure Database for PostgreSQL single servers is scheduled for retirement on March 28, 2025. On this date, changes will be implemented to Azure Backup for PostgreSQL single servers. Learn more [about the retirement announcement here](/azure/postgresql/migrate/whats-happening-to-postgresql-single-server).
  >
  >To understand the changes to Vaulted backups for PostgreSQL single server, see [this section](backup-azure-database-postgresql-overview.md#changes-to-vaulted-backups-for-postgresql-single-server).


sections:
  - name: Backup
    questions:
      - question: What's the backup process of Azure Database for PostgreSQL server?
        answer: |
          Azure Backup and Azure Database Services together help you to build an enterprise-class backup solution for Azure Database for PostgreSQL servers that retains backups for long term. Learn about the complete [backup process](backup-azure-database-postgresql-overview.md#backup-process).

      - question: What are the prerequisites for configuring backup?
        answer: |
          Before configuring database backup, you need to:

          - [Create secrets in the key vault](backup-azure-database-postgresql.md#create-secrets-in-the-key-vault).
          - [Allow access permissions for the relevant key vault](backup-azure-database-postgresql-overview.md#access-permissions-on-the-azure-key-vault-associated-with-the-postgresql-server).
          - [Provide database user's backup privileges on the database](backup-azure-database-postgresql-overview.md#database-users-backup-privileges-on-the-database).
          - [Allow access permissions for PostgreSQL server](backup-azure-database-postgresql-overview.md#access-permissions-on-the-azure-postgresql-server).

      - question: How do I configure backup on Azure PostgreSQL databases?
        answer: You can configure backup on multiple databases across multiple Azure PostgreSQL servers. [Learn more](backup-azure-database-postgresql.md#configure-backup-on-azure-postgresql-databases)

      - question: Can I take an on-demand backup of Azure Database for PostgreSQL server?
        answer: |
          Yes. To trigger an on-demand backup, see [Run on-demand backup](backup-azure-database-postgresql.md#run-an-on-demand-backup).


  - name: Restore
    questions:
      - question: How do I restore PostgreSQL database?
        answer: |
          You can restore as another PostgreSQL database or as files. [Learn about](restore-azure-database-postgresql.md#restore-azure-postgresql-database) the PostgreSQL database restore process.


  - name: Manage database backups
    questions:
      - question: Can I change backup policy?
        answer: |
          Yes, you can change the associated policy with a backup instance. [Learn more](manage-azure-database-postgresql.md#change-policy)

      - question: Can I temporarily stop database backup?
        answer: |
          Yes, to do so, see [Stop Protection and Retain Data](manage-azure-database-postgresql.md#stop-protection-and-retain-data).

      - question: How do I resume database backup?
        answer: |
          If you have selected the **Stop Protection and Retain data** option while stopping the data backup, you can resume protection for your Azure Database for PostgreSQL server. [Learn](manage-azure-database-postgresql.md#resume-protection) how to resume backup.

      - question: How do I delete backup data?
        answer: To delete the backup data, first, stop the backup and then delete backup data. [Learn more](manage-azure-database-postgresql.md#stop-protection-and-delete-data)