From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matthew T. O'Connor <matthew@zeut.net>
Cc: Steve Poe <steve.poe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Planning hot/live backups?
Date: Mon, 24 Mar 2008 18:23:48 -0400
Message-ID: <3769.1206397428@sss.pgh.pa.us> (raw)
In-Reply-To: <47E8128E.1060600@zeut.net>
References: <721b21dc0803241323u73443060w3a1912d52714549b@mail.gmail.com>
<47E8128E.1060600@zeut.net>
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> 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.
But note that you really need to update to a newer major release before
depending on PITR. While 8.0 nominally has support for it, it's taken
us several releases to really get the operational gotchas sorted out.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, matthew@zeut.net, steve.poe@gmail.com
Subject: Re: Planning hot/live backups?
In-Reply-To: <3769.1206397428@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox