From: | Michael Graziano <michael(dot)graziano(at)premierheart(dot)com> |
---|---|
To: | Jesper Krogh <jesper(at)krogh(dot)cc> |
Cc: | Julius Tuskenis <julius(at)nsoft(dot)lt>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Practice of backups |
Date: | 2009-11-19 21:34:10 |
Message-ID: | 9AA38472-FFB0-4BB8-9318-3D50AB4E5B83@premierheart.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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:
> http://www.postgresql.org/docs/8.4/static/continuous-archiving.html
>
> 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.
-MG
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Modra | 2009-11-20 03:32:51 | Re: Just wanted to say thanks for a great tool |
Previous Message | Campbell, Lance | 2009-11-19 21:04:08 | Just wanted to say thanks for a great tool |