Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1D95D2E0051 for ; Mon, 24 Mar 2008 17:57:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 40677-02-2 for ; Mon, 24 Mar 2008 17:57:10 -0300 (ADT) X-Greylist: delayed 00:13:11.187482 by SQLgrey-1.7.5 Received: from smtp110.iad.emailsrvr.com (smtp110.iad.emailsrvr.com [207.97.245.110]) by postgresql.org (Postfix) with ESMTP id 976692E0054 for ; Mon, 24 Mar 2008 17:57:10 -0300 (ADT) Received: from relay1.r1.iad.emailsrvr.com (localhost [127.0.0.1]) by relay1.r1.iad.emailsrvr.com (SMTP Server) with ESMTP id 282B444C1BB; Mon, 24 Mar 2008 16:43:58 -0400 (EDT) Received: by relay1.r1.iad.emailsrvr.com (Authenticated sender: matthew-AT-zeut.net) with ESMTP id 0096444C1B2; Mon, 24 Mar 2008 16:43:57 -0400 (EDT) Message-ID: <47E8128E.1060600@zeut.net> Date: Mon, 24 Mar 2008 16:43:58 -0400 From: "Matthew T. O'Connor" User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Steve Poe CC: pgsql-performance@postgresql.org Subject: Re: Planning hot/live backups? References: <721b21dc0803241323u73443060w3a1912d52714549b@mail.gmail.com> In-Reply-To: <721b21dc0803241323u73443060w3a1912d52714549b@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/449 X-Sequence-Number: 29403 Steve Poe wrote: > The owners of the animal hospital where I work at want to consider live/hot > backups through out the day so we're less likely to lose a whole > day of transaction. We use Postgresql 8.0.15. We do 3AM > backups, using pg_dumpall, to a file when there is very little activity. You probably want to look into PITR, you can have a constant ongoing backup of your data and never lose more than a few minutes of data. The overhead isn't all the big especially if you are shipping the log files to a separate server.