Re: Best backup strategy for production systems

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: Best backup strategy for production systems
Дата
Msg-id CABRT9RAXzUa=_zT_M4Z1vyDuFkpgNCZLUnRTUO5gvK2kKkNu=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Best backup strategy for production systems  (Borislav Ivanov <bivanov@atlassian.com>)
Список pgsql-general
On Fri, Jun 20, 2014 at 1:47 AM, Borislav Ivanov <bivanov@atlassian.com> 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: pros/cons of using "synchronous commit=off" - AWS in particular
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pros/cons of using "synchronous commit=off" - AWS in particular