Backup PostgreSQL

Question

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.

Answer 1

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.