Обсуждение: Backup and Restore
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
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
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
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