0

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]
John K. N.
18.9k14 gold badges56 silver badges117 bronze badges
asked May 15, 2019 at 5:47
1
  • What you show is not a runnable command. It is the synopsis from the man page. Please show the command you run. Commented May 15, 2019 at 13:19

1 Answer 1

1

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.

answered May 15, 2019 at 6:18

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.