Backup PostgreSQL

Glenn Maxwell 6,546 Reputation points
2022-12-28T05:45:08.29+00:00

Hi All

i have Azure Database for PostgreSQL server(Resource Type: Azure Database for PsotgreSQL flexible server).
I want to take the backup as application team is performing an upgrade.

SQL Server on Azure Virtual Machines
Azure Database for PostgreSQL
No comments
{count} votes

Accepted answer
  1. ShaktiSingh-MSFT 4,676 Reputation points Microsoft Employee
    2022-12-28T06:51:23.973+00:00

    Hi @Glenn Maxwell ,

    Thanks for posting this question in Microsoft Q&A platform and for using Azure services.

    As I understand from the question, you want to backup Azure PostgresSQL manually.

    You can manually take a backup by using the PostgreSQL tool pg_dump.
    pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers).For examples, see Migrate your PostgreSQL database by using dump and restore.

    Hope this will help. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

    No comments

0 additional answers

Sort by: Most helpful