Re: Backup taking long time !!!

[Vladimir Borodin <root@xxxxxxxxxxx>]

20 янв. 2017 г., в 15:22, Stephen Frost <sfrost@xxxxxxxxxxx> написал(а):

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.

Increments in pgbackrest are done on file level which is not really efficient. We have done parallelism, compression and page-level increments (9.3+) in barman fork [1], but unfortunately guys from 2ndquadrant-it don’t hurry to work on it.

And actually it would be much better to do a good backup and recovery manager part of the core postgres.

[1] https://github.com/secwall/barman

[2] https://github.com/2ndquadrant-it/barman/issues/21

--

May the force be with you…

https://simply.name