Re: Are file system level differential/incremental backups possible?

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.)

In response to

Browse pgsql-general by date

  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?