Re: Pg_dump backup - Mailing list pgsql-admin

From Ron
Subject Re: Pg_dump backup
Date
Msg-id 17994ffb-4dac-99aa-b889-523d2f579c83@gmail.com
Whole thread Raw
In response to Pg_dump backup  (Daulat <daulat.dba@gmail.com>)
Responses Re: Pg_dump backup  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
On 2/23/22 8:14 AM, Daulat wrote:
> H Team,
>
> I need your advice.
> How can we ensure the pg_dump backup is successful?

Check the return code immediately after pg_dump completes:
pg_dump ....
echo $?

If it's 0, then pg_dump exited successfully.

Of course, it's always good to test the dump files by restoring them on 
non-prod systems.

-- 
Angular momentum makes the world go 'round.



pgsql-admin by date:

Previous
From: "Dischner, Anton"
Date:
Subject: AW: Pg_dump backup
Next
From: Holger Jakobs
Date:
Subject: Re: Pg_dump backup