Share via

query on postgres SQL

Glenn Maxwell 12,011 Reputation points
2023-05-17T03:45:47.52+00:00

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.

Azure Database for PostgreSQL
Accepted answer
  1. Vahid Ghafarpour 22,310 Reputation points
    2023-05-17T03:54:16.5633333+00:00

    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>
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.