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@xxxxxxxxx CK Software GmbH http://www.cksoft.de/ Phone: +49 7452 889 135 Fax: +49 7452 889 136
