From: Steve Poe <steve.poe@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Matthew T. O'Connor <matthew@zeut.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Planning hot/live backups?
Date: Mon, 24 Mar 2008 15:49:40 -0700
Message-ID: <721b21dc0803241549y3ab1b4e7iff7cf8aec66e48d7@mail.gmail.com> (raw)
In-Reply-To: <3769.1206397428@sss.pgh.pa.us>
References: <721b21dc0803241323u73443060w3a1912d52714549b@mail.gmail.com>
<47E8128E.1060600@zeut.net>
<3769.1206397428@sss.pgh.pa.us>
Tom,
So, are you saying we need to get to at least 8.1.x before considering PITR
for a production environment? Unfortunately, the vendor/supplier of
our veterinary application
does not support higher versions. We would be proceeding "at our own risk".
Is there anything else we can do we 8.0.15 version?
Steve
On Mon, Mar 24, 2008 at 3:23 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> "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: steve.poe@gmail.com, tgl@sss.pgh.pa.us, matthew@zeut.net
Subject: Re: Planning hot/live backups?
In-Reply-To: <721b21dc0803241549y3ab1b4e7iff7cf8aec66e48d7@mail.gmail.com>
* 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