Re: Backup WAL Replication Server

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Backup WAL Replication Server
Дата
Msg-id CAB7nPqTR+7MP1Mh2BupsX7GatNq-dPzxQ8cKnH_BXSyh8pxMjg@mail.gmail.com
обсуждение исходный текст
Ответ на Backup WAL Replication Server  (basti <mailinglist@unix-solution.de>)
Список pgsql-general
On Thu, Mar 20, 2014 at 9:48 PM, basti <mailinglist@unix-solution.de> wrote:
> at the moment we use a Postgres Server as Master and one as Hot-Standby.
> The Database is around 50GB and will massive grow next time.
>
> Backup and Restore with pg_dump take several hours, is there a faster
> way to do this?
Everything is here:
http://www.postgresql.org/docs/devel/static/backup.html
Roughly, taking periodic base backups and maintaining WAL archives is
the way to go.
Regards
--
Michael


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

Предыдущее
От: José Pedro Santos
Дата:
Сообщение: Re: Dump Database
Следующее
От: basti
Дата:
Сообщение: WAL Replication Server + repmgr + Slony