Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4763764FCBE for ; Tue, 21 Oct 2008 12:28:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94171-06 for ; Tue, 21 Oct 2008 12:28:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ds528.dedicated.turbodns.co.uk (ds528.dedicated.turbodns.co.uk [81.21.72.118]) by postgresql.org (Postfix) with ESMTP id D196264FC60 for ; Tue, 21 Oct 2008 12:28:33 -0300 (ADT) Received: (qmail 82817 invoked from network); 21 Oct 2008 15:28:07 -0000 Received: from howardnews@selestial.com by ds528.dedicated.turbodns.co.uk by uid 1005 with qmail-scanner-1.22 ( Clear:RC:1(62.3.231.11):. Processed in 0.023226 secs); 21 Oct 2008 15:28:07 -0000 Received: from unknown (HELO ?10.202.6.101?) (selestial-howard.cole@62.3.231.11) by ds528.dedicated.turbodns.co.uk with SMTP; 21 Oct 2008 15:28:06 -0000 Message-ID: <48FDF533.1020400@selestial.com> Date: Tue, 21 Oct 2008 16:28:51 +0100 From: Howard Cole User-Agent: Thunderbird 2.0.0.17 (Windows/20080914) MIME-Version: 1.0 To: "Reuven M. Lerner" , 'PgSql General' Subject: Re: [PERFORM] Backup strategies References: <48F4D693.9000304@lerner.co.il> In-Reply-To: <48F4D693.9000304@lerner.co.il> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/913 X-Sequence-Number: 139162 Reuven M. Lerner wrote: > I'm running a medium-traffic Web site that has been running for a few > years, and which uses about four PostgreSQL databases on a regular > basis. I'm currently running 8.2, although I'm planning to upgrade to > 8.3 in the coming week or two, in part because of the problems that > I'm having. The databases consume a combined total of 35 GB. Like a > good boy, I've been backing the system up overnight, when we have less > traffic, since the site began to run. I use pg_dump to back up, > saving both schemas and data for a full restore in case of failure. > pg_dump typically executes from another machine on a local network; if > it would help to run pg_dump locally, then I'm certainly open to doing > that. > One point to note with continuous archiving, if your four databases are in the same cluster, then restoring the archive will restore all your databases to the same point in time. So you cannot, as far as I am aware, restore just one of the four databases. Howard.