X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2650F11F676F for ; Wed, 12 Apr 2006 12:53:18 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id dJU+IwClpx1G for ; Wed, 12 Apr 2006 12:53:15 -0300 (ADT) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 84D0811F6768 for ; Wed, 12 Apr 2006 12:53:15 -0300 (ADT) Received: from localhost (unknown [200.46.204.254]) by hub.org (Postfix) with ESMTP id 96E3662C83D for ; Wed, 12 Apr 2006 12:53:15 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org Received: from hub.org ([200.46.204.220]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id 0tN-LJNN15MD for ; Wed, 12 Apr 2006 12:53:09 -0300 (ADT) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 35CF962C83C for ; Wed, 12 Apr 2006 12:53:09 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id DBCFA38DC9; Wed, 12 Apr 2006 12:53:07 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id CE937368EA for ; Wed, 12 Apr 2006 12:53:07 -0300 (ADT) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Wed, 12 Apr 2006 06:05:28 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from ganymede.hub.org (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 70D6D47DA6 for ; Wed, 12 Apr 2006 06:05:28 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by ganymede.hub.org with IMAP (fetchmail-6.3.2) for (single-drop); Wed, 12 Apr 2006 06:05:28 -0300 (ADT) X-Received: from postgresql.org ([unix socket]) by postgresql.org (Cyrus v2.2.12) with LMTPA; Wed, 12 Apr 2006 06:03:08 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 2478111F690A for ; Wed, 12 Apr 2006 06:03:08 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id oxwkkdu582HQ for ; Wed, 12 Apr 2006 06:03:01 -0300 (ADT) X-Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id 1745511F692C for ; Wed, 12 Apr 2006 06:03:00 -0300 (ADT) X-Original-To: pgsql-docs-postgresql.org-owner@localhost.postgresql.org X-Delivered-To: pgsql-docs-postgresql.org-owner@localhost.postgresql.org X-Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id D11CD11F690B for ; Wed, 12 Apr 2006 06:02:59 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id UeNoN99Ybsz7 for ; Wed, 12 Apr 2006 06:02:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Received: from ptb-relay02.plus.net (ptb-relay02.plus.net [212.159.14.213]) by postgresql.org (Postfix) with ESMTP id 9FE2B11F6922 for ; Wed, 12 Apr 2006 06:02:51 -0300 (ADT) X-Received: from [213.162.97.75] (helo=mail.metronet.co.uk) by ptb-relay02.plus.net with esmtp (Exim) id 1FTbFS-00024p-NW for pgsql-docs-owner@postgresql.org; Wed, 12 Apr 2006 10:02:50 +0100 X-Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id DB2897362E for ; Wed, 12 Apr 2006 10:04:36 +0100 (BST) X-Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 08D3E15EA4 for ; Wed, 12 Apr 2006 10:02:49 +0100 (BST) Message-ID: <443CC239.7010303@archonet.com> Date: Wed, 12 Apr 2006 10:02:49 +0100 From: Richard Huxton User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: pgsql-docs-owner@postgresql.org Subject: Proposed doc-patch: Identifying the Current WAL file Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit ReSent-Date: Wed, 12 Apr 2006 12:53:02 -0300 (ADT) ReSent-From: "Marc G. Fournier" ReSent-To: pgsql-docs@postgresql.org ReSent-Subject: Proposed doc-patch: Identifying the Current WAL file ReSent-Message-ID: <20060412125302.Q1096@ganymede.hub.org> X-Archive-Number: 200604/25 X-Sequence-Number: 3524 Reading Tom's posting here: http://archives.postgresql.org/pgsql-general/2006-04/msg00499.php I just realised we don't seem to mention this in the docs anywhere. I propose adding a short paragraph to 23.3.1 http://www.postgresql.org/docs/8.1/static/backup-online.html#BACKUP-ONLINE-CAVEATS After "Except in the case of retrying a failure, it will be called only once for any given file name." To identify the current, partially-filled WAL segment, sort first by mtime and second by file name. That is, take the latest mtime among the properly-named files, breaking ties by taking the higher filename. -- Richard Huxton Archonet Ltd