Re: [GENERAL] [pgadmin-support] Best backup strategy for production systems

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] [pgadmin-support] Best backup strategy for production systems
Дата
Msg-id CAB7nPqQ8mN3coVgTZqX4yc1w2djTXi+L4=pcZrhXuZkJNT+uKg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [pgadmin-support] Best backup strategy for production systems  (Oliver <ofabelo@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Please avoid top-posting...

On Mon, Jun 30, 2014 at 7:24 PM, Oliver <ofabelo@gmail.com> wrote:
Ok, thanks.
I mean by original wal segments to files generated in pg_xlog, yes. I have to 0 the parameter wal_keep_segments. They are being generated with 16MB of size and they are being rotated. What parameter controls how many files can be generated? Or will it grow indefinitely?
checkpoint_segments. A maximum of (3 * checkpoint_segments + 1) WAL segments can generated. This can be more though as this is a soft limit, but once this limit is reached server will remove WAL segments instead of keeping them. Per the docs:
http://www.postgresql.org/docs/9.3/static/wal-configuration.html
--
Michael

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

Предыдущее
От: Oliver
Дата:
Сообщение: Re: [GENERAL] [pgadmin-support] Best backup strategy for production systems
Следующее
От: Luis Marin
Дата:
Сообщение: PostgreSql 9.3 High Availability Best Practices