Re: postgres wal log configuration question - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: postgres wal log configuration question
Date
Msg-id DF39D2B0-2FAC-47CE-AB03-959BB9012A7A@crazybean.net
Whole thread Raw
In response to Re: postgres wal log configuration question  (Pavan Kumar <pavan.dba27@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to create a postgres user that auth by AUTH_REQ_MD5
Next
From: Jeremy Schneider
Date:
Subject: Re: Query on pg_stat_activity table got stuck