I am new to PostgreSQL and have questions regarding the backup procedure.

How do I check whether a PostgreSQL database was backed up successfully? And how do I monitor the backup?

I have tried the following command to backup the database, but there's no output:

pg_dump [connection-option...] [option...] [dbname]
  • What you show is not a runnable command. It is the synopsis from the man page. Please show the command you run. – jjanes May 15 '19 at 13:19

The test is to restore the backup somewhere else.

Monitoring can be done via the return code of pg_dump: if that isn't 0, something went wrong.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.