Re: postgres wal log configuration question

[Rui DeSousa <rui@xxxxxxxxxxxxx>]

On May 9, 2019, at 8:32 AM, Pavan Kumar <pavan.dba27@xxxxxxxxx> 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:

https://paquier.xyz/postgresql-2/postgres-9-3-feature-highlight-pg_xlogdump/