Postgres Pro
Downloads
Home   >   mailing lists

Thread: Pg_dump backup

Pg_dump backup

From
Daulat
Date:
H Team,

I need your advice. 
How can we ensure the pg_dump backup is successful?

Thanks !
Daulat 

AW: Pg_dump backup

From
"Dischner, Anton"
Date:

Hi Daulat,

 

how about to import it into a fresh installed postgresql instance.

 

A new dockerized version you can delete after install comes to my mind,

 

best,

 

Anton

 

Von: Daulat <daulat.dba@gmail.com>
Gesendet: Mittwoch, 23. Februar 2022 15:15
An: pgsql-admin <pgsql-admin@lists.postgresql.org>
Betreff: Pg_dump backup

 

H Team,

 

I need your advice. 

How can we ensure the pg_dump backup is successful?

 

Thanks !

Daulat 

Re: Pg_dump backup

From
Ron
Date:
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.

Re: Pg_dump backup

From
Holger Jakobs
Date:
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