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 C30219FB1E3 for ; Tue, 1 Aug 2006 15:09:17 -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 91741-06 for ; Tue, 1 Aug 2006 15:09:11 -0300 (ADT) X-Greylist: from auto-whitelisted 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 668A29FB1BC for ; Tue, 1 Aug 2006 15:09:11 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:32828 helo=[192.168.1.15]) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1G7yg0-0005qt-MT; Tue, 01 Aug 2006 19:09:08 +0100 Message-ID: <44CF98C3.7010706@mailnetwork.co.uk> Date: Tue, 01 Aug 2006 19:09:07 +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.416 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/13 X-Sequence-Number: 22557 hi mr d, yes i would say you have a problem with the 8.1.4's archive-command - sorry most of my keyboard keys have stopped working so i can't use capitals or punctuation lol. check your latest logs on the 8.1.4 server for errors in archiving that file. when you've done a backup, that .backup file should be archived with the archive-command, the same as the normal wal logs - the .backup.done file is not written because postgres couldn't archive the file for some reason - check your logs is about the best i can advise. sorry for the amateurish email - i'm off to replace my keyboard andy. Mr. Dan wrote: > Hey Andy, > > Sorry for the confusion. That file and the one in archive_status > (*.backup.done) are from v810. I'm wondering why my PITR backup in > v814 doesn't leave me with similiear files. Neither *.backup in > pg_xlog or *.backup.done in archive_status shows up. I was wondering > if that was by design or I have a problem. > > ~DjK > > > > > >> From: Andy Shellam >> Reply-To: Andy Shellam >> To: "Mr. Dan" >> CC: pgsql-admin@postgresql.org >> Subject: Re: [ADMIN] online backup - v810 vs. v814 >> Date: Tue, 01 Aug 2006 17:05:45 +0100 >> >> 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,44cf9118143292966821177! > >