Re: WAL and pg_dump - Mailing list pgsql-admin

From Stephen Frost
Subject Re: WAL and pg_dump
Date
Msg-id 20051223175430.GI6026@ns.snowman.net
Whole thread Raw
In response to Re: WAL and pg_dump  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
* Simon Riggs (simon@2ndquadrant.com) wrote:
> On Fri, 2005-12-23 at 08:43 -0500, Stephen Frost wrote:
> > Of course, I can also do snapshots with the SAN, but that's a
> > one-time thing unlike PITR where you can choose any point in time to
> > recover to.
>
> Why not use SAN Snapshots *and* PITR? They play nicely.

Yeah, that's something we're working towards actually.  I havn't played
with the command-line client quite enough yet to be comfortable sticking
it in a script to do the snapshotting.  We also don't have everything on
the SAN (some things can't be due to different security requirements and
some paranoia) so we're making sure that what we're doing will work for
those systems as well.  Once I'm happier with the SAN command-line
client I might substitute that in for the tar generation we're doing now
for those databases on the SAN.

    Thanks,

        Stephen

Attachment

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: WAL and pg_dump
Next
From: Alain Rodriguez Arias
Date:
Subject: Re: lo_ functions