Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hOjr2-0004xf-7l for pgsql-admin@arkaria.postgresql.org; Thu, 09 May 2019 14:17:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hOjr0-0004qx-UB for pgsql-admin@arkaria.postgresql.org; Thu, 09 May 2019 14:16:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hOjr0-0004no-Gh for pgsql-admin@lists.postgresql.org; Thu, 09 May 2019 14:16:58 +0000 Received: from impout008aa.msg.chrl.nc.charter.net ([47.43.20.32] helo=impout008.msg.chrl.nc.charter.net) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hOjqx-0003GU-S9 for pgsql-admin@lists.postgresql.org; Thu, 09 May 2019 14:16:57 +0000 Received: from cerberus.crazybean.net ([24.151.10.150]) by cmsmtp with ESMTP id OjqwhxEFIMMJtOjqwh2EXt; Thu, 09 May 2019 14:16:54 +0000 Authentication-Results: crazybean.net; none X-Authority-Analysis: v=2.3 cv=QtjqIm6d c=1 sm=1 tr=0 a=D2HTw/M6/8MmcHighGO7rg==:117 a=D2HTw/M6/8MmcHighGO7rg==:17 a=jpOVt7BSZ2e4Z31A5e1TngXxSK0=:19 a=xqWC_Br6kY4A:10 a=E5NmQfObTbMA:10 a=pGLkceISAAAA:8 a=HvnWhiLzAAAA:8 a=MVOP_me5Fl_rXFcmHqMA:9 a=QEXdDO2ut3YA:10 a=-FEs8UIgK8oA:10 a=NWVoK91CQyQA:10 a=W9aaMmxux8cZt4nD-fsA:9 a=BEvNoP3z642mbb6i:21 a=_W_S_7VecoQA:10 a=YT91KPC6OSPBWssVLg7J:22 Received: from [IPv6:2001:470:e117:4:6873:7779:5194:f0b9] (2001:470:e117:4:6873:7779:5194:f0b9 [IPv6:2001:470:e117:4:6873:7779:5194:f0b9]) by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id 201e1568 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO); Thu, 9 May 2019 10:16:54 -0400 (EDT) From: Rui DeSousa Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_7E635A6F-EE95-4D76-BACD-50770714B7AE" Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.8\)) Subject: Re: postgres wal log configuration question Date: Thu, 9 May 2019 10:16:53 -0400 In-Reply-To: Cc: pgsql-admin@lists.postgresql.org To: Pavan Kumar References: <56496583-595D-4267-A5F3-7C1AA877345A@crazybean.net> X-Mailer: Apple Mail (2.3445.104.8) X-CMAE-Envelope: MS4wfPArvU/gZhlMZbsTVO90F0yuo+9iVVdFszwkE78mHiWETOqTkpA6tZwp69XZHoA+TF7+L+mpwKvl6zjeuQZgfUzk1BFu3p1EBNTvawErp9R9oI/Y5JOW ftWRSARJSFCdk7zLkUN91QzLAGQm0ghJKZqE23a41/iILiK9u5uieC0S5SOsaYbNZgz/VivElTT3eY1HwUksez/bEZQRdo8FmFTy4qb8hnCOzRt9fZNdu5At List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_7E635A6F-EE95-4D76-BACD-50770714B7AE Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On May 9, 2019, at 8:32 AM, Pavan Kumar wrote: >=20 > 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=E2=80=99s 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_xlogdum= p/ = --Apple-Mail=_7E635A6F-EE95-4D76-BACD-50770714B7AE Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

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=E2=80=99s 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/


= --Apple-Mail=_7E635A6F-EE95-4D76-BACD-50770714B7AE--