X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id DF9FD11F66BD for ; Sat, 15 Apr 2006 14:58:03 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.024 X-Spam-Level: X-Spam-Status: No, score=-2.024 required=5 tests=[AWL=0.577, BAYES_00=-2.599, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id ISUJm9Xh9E2p for ; Sat, 15 Apr 2006 14:57:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 8A57911F6699 for ; Sat, 15 Apr 2006 14:57:53 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k3FHvhpY020275; Sat, 15 Apr 2006 13:57:43 -0400 (EDT) To: Bruce Momjian cc: Jeff Frost , Richard Huxton , pgsql-docs@postgresql.org Subject: Re: Proposed doc-patch: Identifying the Current WAL file In-reply-to: <200604151726.k3FHQvI01801@candle.pha.pa.us> References: <200604151726.k3FHQvI01801@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Sat, 15 Apr 2006 13:26:57 -0400" Date: Sat, 15 Apr 2006 13:57:43 -0400 Message-ID: <20274.1145123863@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200604/14 X-Sequence-Number: 3513 Bruce Momjian writes: > Also, what happens if the log switch happens, and some data change is > written to the new WAL file in the first second, but nothing happens to > the database after that for a minute? Your test would still show the > old log file. You seem to be assuming that ls will sort on the basis of the truncated mtime that it displays, which is not the actual behavior of ls AFAIK. regards, tom lane