Re: Pg_dump backup

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Pg_dump backup
Date: 2022-02-23 14:45:28
Message-ID: 17994ffb-4dac-99aa-b889-523d2f579c83@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2022-02-23 15:00:27 Re: Pg_dump backup
Previous Message Dischner, Anton 2022-02-23 14:30:13 AW: Pg_dump backup