Re: Pg_dump backup

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.