query on postgres SQL

Question

Hi all

i have DB in Azure Database for PostgreSQL servers. is it possible to take manual backup for this. Under backup and restore i dont see option to take manual backup. Please guide me if manual backup can be taken.

Answer 1

Did you try pg_dump?

pg_dump -h <server_name>.postgres.database.azure.com -U <username>@<server_name> -p 5432 -f <backup_file_name>.sql <database_name>