Re: [GENERAL] tar error while running basebackup

2009-10-13 Thread Andre Brandt
How can this happen? I always thought, that, when in backup mode, nothing is able to change the database - so the database files shouldn't change. Can autovaccumdb cause the changes? pg_start_backup() doesn't tell the database to stop writing changes to disk; it essentially just says "

[GENERAL] tar error while running basebackup

2009-10-13 Thread Andre Brandt
Hi! We're using two backup strategies to get consistent backups of our postgresql databases. First, we create a complete dump every night by running pg_dump, zipping the file and writing this backup on tape. Second, we create a basebackup every saturday. To create a basebackup, we run pg_start