Thread: Backup and Restore

Backup and Restore

From
Dor Ben Dov
Date:

Hi,

 

What is the most common used back and restore solution for postgres ?

Which one are you using ?

 

 

Regards,

Dor

This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service

Re: Backup and Restore

From
Adrian Klaver
Date:
On 12/12/19 7:12 AM, Dor Ben Dov wrote:
> Hi,
> 
> What is the most common used back and restore solution for postgres ?

I would say it goes from pg_dump/pg_restore for smaller databases to 
some form of replication for larger.

> 
> Which one are you using ?

I use pg_dump/pg_restore and have started using 
pgBackrest(https://pgbackrest.org/user-guide.html).

> 
> Regards,
> 
> Dor
> 
> *This email and the information contained herein is proprietary and 
> confidential and subject to the Amdocs Email Terms of Service, which you 
> may review at**https://www.amdocs.com/about/email-terms-of-service*
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



Re: Backup and Restore

From
Grigory Smolkin
Date:

Hello!

I would recommend to look at pg_probackup:
https://github.com/postgrespro/pg_probackup

On 12/12/19 6:12 PM, Dor Ben Dov wrote:

Hi,

 

What is the most common used back and restore solution for postgres ?

Which one are you using ?

 

 

Regards,

Dor

This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service

-- 
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Re: Backup and Restore

From
Andreas Kretschmer
Date:

Am 12.12.19 um 16:12 schrieb Dor Ben Dov:
> What is the most common used back and restore solution for postgres ?

most of our customers are using Barman, which is not a surprise since it 
is developed by us ;-)


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com