Backup and Restore

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