From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | Decibel! <decibel(at)decibel(dot)org> |
Cc: | "Joey K(dot)" <pguser(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Seeking datacenter PITR backup procedures [RESENDING] |
Date: | 2007-08-23 22:58:36 |
Message-ID: | 20070823185836.f5922c09.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Decibel! <decibel(at)decibel(dot)org> wrote:
>
> On Aug 19, 2007, at 7:23 AM, Bill Moran wrote:
> >> Assumptions:
> >> a. After pg_stop_backup(), Pg immediately recycles log files and
> >> hence wal
> >> logs can be copied to backup. This is a clean start.
> >
> > I don't believe so. ARAIK, all pg_stop_backup() does is remove the
> > marker that pg_start_backup() put in place to tell the recovery
> > process
> > when the filesystem backup started.
>
> I'm pretty certain that's not the case. For a PITR to ensure that
> data is back to a consistent state after a recovery, it has to replay
> all the transactions that took place between pg_start_backup and
> pg_stop_backup; so it needs to know when pg_stop_backup() was
> actually run.
Sounds likely ... but I don't believe that forces any specific log
cycling activity, like the OP suggested.
Be nice if someone who knew for sure would chime in ;)
> > By not backing up pg_xlog, you are
> > going to be behind by however many transactions are in the most recent
> > transaction log that has not yet been archived. Depending on how
> > often
> > your databases are updated, this is likely acceptable. If you need
> > anything more timely than that, you'll probably want to implement
> > Slony or some other replication system.
>
> Just keep in mind that Slony is *not* a backup solution (though you
> could possibly argue that it's log shipping is).
True. This rides the fine line of the difference between an HA setup
and backup. Specifically: HA won't allow you to recovery from user
error.
--
Bill Moran
http://www.potentialtech.com
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2007-08-24 00:20:34 | Re: %TYPE |
Previous Message | Hannes Dorbath | 2007-08-23 22:43:14 | Re: Apache + PHP + Postgres Interaction |