Re: postgres wal log configuration question

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: postgres wal log configuration question
Дата
Msg-id DF39D2B0-2FAC-47CE-AB03-959BB9012A7A@crazybean.net
обсуждение исходный текст
Ответ на Re: postgres wal log configuration question  (Pavan Kumar <pavan.dba27@gmail.com>)
Список pgsql-admin


On May 9, 2019, at 8:32 AM, Pavan Kumar <pavan.dba27@gmail.com> wrote:

 is there anyway to control wal segment naming format.  wal segment file is not generating in sequential format.

Not really; however the file names are sequential based on the timeline and log sequence.  If you change the WAL segment size then the WAL file name sequence will change; i.e. 16MB vs 128MB WAL files will generate different sequences.

Here’s a article that covers the three parts of the filename; timeline_id, block id, and segment id:



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to create a postgres user that auth by AUTH_REQ_MD5
Следующее
От: Jeremy Schneider
Дата:
Сообщение: Re: Query on pg_stat_activity table got stuck