X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C568C8B9B5E for ; Wed, 23 Feb 2005 01:37:33 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86154-05 for ; Wed, 23 Feb 2005 01:37:19 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 2A30D8B9E33 for ; Wed, 23 Feb 2005 01:37:22 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j1N1bIJt087457 for ; Wed, 23 Feb 2005 01:37:18 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j1N1PorK084706 for pgsql-admin@postgresql.org; Wed, 23 Feb 2005 01:25:50 GMT (envelope-from news) From: Gaetano Mendola X-Newsgroups: pgsql.admin Subject: Re: Determining current WAL Date: Wed, 23 Feb 2005 02:25:16 +0100 Organization: Hub.Org Networking Services Lines: 26 Message-ID: <421BDB7C.1040401@bigfoot.com> References: <7183.1108654412@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Tom Lane User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <7183.1108654412@sss.pgh.pa.us> X-Enigmail-Version: 0.90.1.1 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200502/245 X-Sequence-Number: 16413 Tom Lane wrote: > thomas.revell@powerconv.alstom.com writes: > >>I'm currently looking at using WAL / PITR backups for a database, and I >>need to keep the backups as up to date as possible. As such, keeping a >>copy of the current WAL file, as suggested in the manual, would seem to be >>a very good idea. I'm slightly confused, though, about which file is the >>current. I had assumed that it would always be the highest numbered, > > > No. Go with the most-recently-modified. Segment files are normally > created (or renamed into place) in advance of being needed. > > There should probably be a cleaner/more reliable way of identifying > the active file ... Yes it was discussed during the attempt to create the log delivery to another server in "replay" state, if the master was not responding then it was usefull have a way to identify the active wal segment, at the time I was identifing the current wall the last created one Regards Gaetano Mendola