| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Pg_dump backup |
| Date: | 2022-02-23 15:00:27 |
| Message-ID: | ec9f488c-586e-b006-6209-1725c1cb2c69@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Axel Rau | 2022-02-23 20:46:43 | [RESOLVED] Re: restarting logical replication after upgrading standby |
| Previous Message | Ron | 2022-02-23 14:45:28 | Re: Pg_dump backup |