Re: [PERFORM] Backup taking long time !!! - Mailing list pgsql-performance

From Stephen Frost
Subject Re: [PERFORM] Backup taking long time !!!
Date
Msg-id 20170120122224.GF18360@tamriel.snowman.net
Whole thread Raw
In response to Re: [PERFORM] Backup taking long time !!!  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance
* Pavel Stehule (pavel.stehule@gmail.com) wrote:
> 2017-01-20 12:53 GMT+01:00 Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>:
> > Thanks for quick response.
> >
> > May I know how can I use physical full backup with export transaction
> > segments.
> >
>
> https://www.postgresql.org/docs/9.1/static/continuous-archiving.html
>
> This process can be automatized by some applications like barman
> http://www.pgbarman.org/

Last I checked, barman is still single-threaded.

If the database is large enough that you need multi-process backup, I'd
suggest looking at pgbackrest- http://www.pgbackrest.org.

pgbackrest has parallel backup, incremental/differential/full backup
support, supports compression, CRC checking, and a whole ton of other
good stuff.

Thanks!

Stephen

Attachment

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [PERFORM] Backup taking long time !!!
Next
From: Vladimir Borodin
Date:
Subject: Re: [PERFORM] Backup taking long time !!!