X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87F12D9106 for ; Fri, 30 Sep 2005 06:14:15 -0300 (ADT) 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 11674-01 for ; Fri, 30 Sep 2005 09:14:08 +0000 (GMT) Received: from smtp2.freeserve.com (smtp2.wanadoo.co.uk [193.252.22.157]) by svr1.postgresql.org (Postfix) with ESMTP id AF91BD9001 for ; Fri, 30 Sep 2005 06:14:09 -0300 (ADT) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf3102.me.freeserve.com (SMTP Server) with ESMTP id DA93F240008A; Fri, 30 Sep 2005 11:14:10 +0200 (CEST) Received: from 192.168.0.102 (modem-3574.lion.dialup.pol.co.uk [217.135.173.246]) by mwinf3102.me.freeserve.com (SMTP Server) with ESMTP id 66DEC2400082; Fri, 30 Sep 2005 11:14:10 +0200 (CEST) X-ME-UUID: 20050930091410421.66DEC2400082@mwinf3102.me.freeserve.com Subject: Re: archive_command From: Simon Riggs To: Kris Kiger Cc: Jeff Frost , pgsql-admin@postgresql.org In-Reply-To: <433ACE02.3040208@musicrebellion.com> References: <20031115132118.V74587@holywar.net> <433AC059.1050300@musicrebellion.com> <433ACE02.3040208@musicrebellion.com> Content-Type: text/plain Organization: 2nd Quadrant Date: Fri, 30 Sep 2005 10:13:47 +0100 Message-Id: <1128071627.19345.256.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.052 required=5 tests=[AWL=0.002, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/330 X-Sequence-Number: 19067 On Wed, 2005-09-28 at 12:08 -0500, Kris Kiger wrote: > My question then is, how do we tell which wal log is X (the one > currently being written to)? You don't say why you need to know? If you really care, you can look at the status files in the archive_status directory underneath pg_xlog. This is where the archiver checks to see for notifications of filled WAL files, then clears the notification afterwards. Only filled WAL filenames are shown. Don't touch the files or you might interfere with the archiver's activities. Best Regards, Simon Riggs