X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 667079DCE3A for ; Sat, 25 Mar 2006 13:51:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86876-04 for ; Sat, 25 Mar 2006 13:51:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 0DB5E9DCE25 for ; Sat, 25 Mar 2006 13:51:25 -0400 (AST) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1582 helo=acsdesk1) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FNCv7-000836-Gw; Sat, 25 Mar 2006 17:51:25 +0000 Reply-To: From: "Andy Shellam" To: "'Sriram Dandapani'" , Subject: Re: WAL file naming convention Date: Sat, 25 Mar 2006 17:51:13 -0000 Organization: the mail network MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01C65034.B5AC3080" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF03C4964D@ca-mail1.cis.local> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZPoy+dGKucly53RoqdxSa0YKjFpAAkWQdg Message-Id: <20060325175125.0DB5E9DCE25@postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.875 required=5 tests=[AWL=-0.053, HTML_MESSAGE=0.001, MSGID_FROM_MTA_ID=0.927] X-Spam-Score: 0.875 X-Spam-Level: X-Archive-Number: 200603/259 X-Sequence-Number: 21016 This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C65034.B5AC3080 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit As PostgreSQL numbers WALs sequentially, as long as your ls command by default orders listings by filename, then Yes. Or you could list by the last modified date/time should give the same effect. Andy _____ From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Sriram Dandapani Sent: Saturday, 25 March, 2006 12:30 am To: pgsql-admin@postgresql.org Subject: [ADMIN] WAL file naming convention Hi Is is safe to assume that the unix ls command will return WAL files in the same sequence as postgres creates them. e.g will ls return files in the order that postgres created them !DSPAM:14,44248f2235041511888239! ------=_NextPart_000_0013_01C65034.B5AC3080 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
As PostgreSQL numbers WALs sequentially, as = long as your ls=20 command by default orders listings by filename, then Yes.  Or you = could=20 list by the last modified date/time should give the same=20 effect.
 
Andy


From: = pgsql-admin-owner@postgresql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Sriram=20 Dandapani
Sent: Saturday, 25 March, 2006 12:30 = am
To:=20 pgsql-admin@postgresql.org
Subject: [ADMIN] WAL file naming=20 convention

Hi

 

Is is safe to assume that = the unix=20 ls command will return WAL files in the same sequence as postgres = creates=20 them.

 

e.g will ls = <wal-file-folder>=20 return files in the order that postgres created=20 them

!DSPAM:14,44248f2235041511888239! = ------=_NextPart_000_0013_01C65034.B5AC3080--