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