Re: FW: Setting up of PITR system.

Hi,

On Tue, 11 Apr 2006, Spiegelberg, Greg wrote:
> You should implement filesystem or volume level snapshots. LVM,
> Veritas and the like all have the functionality and it gets the
> database out of "backup" mode quickly.

from what I understand there is no need to keep the time between
pg_start_backup and pg_stop_backup small. The datebase is in no
way restrcited in its operation or performance during this time.

The only magic seems to be the marker file containing the information
which transaction were commited at the time the backup started.

As we run freebsd and our tar does not complain of files changing
underneath we prefer to avoid the additional complexity and of
filesystem snapshots and just plain tar the data directory
without the pg_xlog subdirectory.

Greetings
Christian

--
Christian Kratzer ck(at)cksoft(dot)de
CK Software GmbH http://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136