Re: How to manage WAL

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How to manage WAL
Дата
Msg-id 4B7437B1020000250002F1FD@gw.wicourts.gov
обсуждение исходный текст
Ответ на How to manage WAL  (Albert Shih <Albert.Shih@obspm.fr>)
Ответы Re: How to manage WAL
Список pgsql-admin
Albert Shih <Albert.Shih@obspm.fr> wrote:

> I would like to known what's best way to manage the WAL.

You should design a policy which meets your particular needs.  We
keep two PITR base backups and all the WAL files from before the
start of the first (based on the information in the backup file)
through current.  We also save monthly archival PITR base backups
with just the WAL files needed to restore them (again, based on the
backup files).  Your needs may be different.

-Kevin

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

Предыдущее
От: Albert Shih
Дата:
Сообщение: Re: pg_xlog
Следующее
От: Albert Shih
Дата:
Сообщение: Re: How to manage WAL