On Nov 19, 2009, at 1:58 PM, Jesper Krogh wrote:
> Michael Graziano wrote:
>> None that I know of from within the database environment, but you can
>> grab a copy of the data directory off the filesystem. Note that this
>> requires stopping the DB server though, as a backup grabbed while
>> the DB
>> is running may have issues.
> Not if you have enabled PITR and tell the database that you do so:
> Works excellent..
That's true - I forgot about pg_start_backup / pg_stop_backup (which
is sad considering I use them every time I roll a new slave...)
Doing the backup that way avoids the outage in my filesystem
snapshotting example and isn't dependent on OS-level capabilities so
it's definitely a better way to go.
In response to
pgsql-admin by date
|Next:||From: Brian Modra||Date: 2009-11-20 03:32:51|
|Subject: Re: Just wanted to say thanks for a great tool|
|Previous:||From: Campbell, Lance||Date: 2009-11-19 21:04:08|
|Subject: Just wanted to say thanks for a great tool|