From: | Bob Hatfield <bobhatfield(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Are file system level differential/incremental backups possible? |
Date: | 2011-10-12 23:03:28 |
Message-ID: | CAKikJcLDv0c9k=_CtSdQFd0WWLb9n15g7YrKQaOcLyo1pFPtGA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> The base backup necessary to initialize a warm standby server is a full file system backup of the database, which can also be used for restores to any point in time after the base backup is completed, assuming you also have all the archived WAL files.
Thanks to both of you. I currently use the base backup technique for
use with a warm standby server but was not aware I could use that for
full file system level backups as well.
In fact, I currently run a warm standby server (created from a base
backup every several weeks) as well as stop/start the pg process to do
a full file system level copy each night. If I think about this a
bit, I'm sure there's a more efficient way of doing this. (As well as
may solve another problem I'm having (another post) with the standby
server's database getting corrupt after stopping/starting the
primary's pg process.)
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2011-10-12 23:10:19 | Re: how to key/value iterate in stored function |
Previous Message | Alan Hodgson | 2011-10-12 22:19:58 | Re: Are file system level differential/incremental backups possible? |