X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 665C79FB376 for ; Tue, 1 Aug 2006 13:05:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 58617-10 for ; Tue, 1 Aug 2006 13:05:47 -0300 (ADT) X-Greylist: delayed 04:42:20.434735 by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 6D8B99FB373 for ; Tue, 1 Aug 2006 13:05:47 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:40487 helo=[192.168.1.15]) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1G7wkc-0005OU-7L; Tue, 01 Aug 2006 17:05:46 +0100 Message-ID: <44CF7BD9.4030104@mailnetwork.co.uk> Date: Tue, 01 Aug 2006 17:05:45 +0100 From: Andy Shellam Reply-To: Andy Shellam Organization: The Mail Network User-Agent: Thunderbird 1.5.0.5 (X11/20060719) MIME-Version: 1.0 To: "Mr. Dan" CC: pgsql-admin@postgresql.org Subject: Re: online backup - v810 vs. v814 References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.981 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/10 X-Sequence-Number: 22554 That looks to be a file hanging around from a previous PITR backup. That file should be in your xlog archive. cat the contents and you'll see which backup it belongs to. Andy. Mr. Dan wrote: > Hi, > > I do an online backup with v814 and v810. I've noticed that there is > a file showing up in the PGDATA > directory/pg_xlog/00000000010000251000000C2.0021CDDE.backup owned by > postgres 284 bytes in size that shows up in v810. That file isn't > showing up in v814. Is that by design? > > ~DjK > > > psql -d somedb "SELECT pg_start_backup() > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > !DSPAM:37,44cf7a71143292031717456! > >