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 8C98A9DCA05 for ; Mon, 27 Mar 2006 06:34:45 -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 21597-10 for ; Mon, 27 Mar 2006 06:34:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 428359DC946 for ; Mon, 27 Mar 2006 06:34:43 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 8927056431; Mon, 27 Mar 2006 04:34:45 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Mon, 27 Mar 2006 04:34:44 -0600 Date: Mon, 27 Mar 2006 04:34:44 -0600 From: "Jim C. Nasby" To: Andy Shellam Cc: 'Sriram Dandapani' , pgsql-admin@postgresql.org Subject: Re: WAL file naming convention Message-ID: <20060327103444.GQ80726@pervasive.com> References: <6992E470F12A444BB787B5C937B9D4DF03C4964D@ca-mail1.cis.local> <20060325175125.0DB5E9DCE25@postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060325175125.0DB5E9DCE25@postgresql.org> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060327:andy.shellam@mailnetwork.co.uk::FyUHXyKN2lom424m:0000000 0000000000000000000000004CUv X-Hashcash: 1:20:060327:sdandapani@counterpane.com::tK4+zEDNrTzVn9Ir:00000000000 0000000000000000000000002V4s X-Hashcash: 1:20:060327:pgsql-admin@postgresql.org::xYL00Gv+/OWzVPfB:00000000000 00000000000000000000000000Lm X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/289 X-Sequence-Number: 21046 On Sat, Mar 25, 2006 at 05:51:13PM -0000, Andy Shellam wrote: > 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. But note that the order it creates them in doesn't have much meaning, because it can re-use them. So if you want to know anything about actual current order of usage the filename is meaningless. > _____ > > 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! -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461