Re: Pg_dump backup

[Holger Jakobs <holger@xxxxxxxxxx>]

Am 23.02.22 um 15:45 schrieb Ron:
> 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.
Correct. On top of this you can also look for these lines at the bottom 
of the dump

--
-- PostgreSQL database dump complete
--


--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Attachment: OpenPGP_signature
Description: OpenPGP digital signature