Search Postgresql Archives

Re: Best backup strategy for production systems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Jun 20, 2014 at 1:47 AM, Borislav Ivanov <bivanov@xxxxxxxxxxxxx> wrote:
> If your database is relatively small, I would recommend
> http://www.pgbarman.org/. It does binary backup and will take care of your
> WAL files. The laster version of pgbarman can also take backups from a slave
> using pgespresso extension. Note that pgbarman runs over streaming
> replication protocol.

I would advise against barman for smaller installations. The setup is
complicated and there are too many moving parts (requires SSH hole
punching in two directions AND a streaming replication connection). I
found WAL-E to be much easier to manage.

Regards,
Marti



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux