Re: [GENERAL] Consistent file-level backup of pg data directory

On 01/08/14 19:55, Jeff Janes wrote: I think it would be easier to just exclude the database from the system-wide backup and use a different method for it, rather than engineer the necessary before/after hooks onto the system-wide backup. Thanks for your comments! I really thought, it would be

Re: [GENERAL] Consistent file-level backup of pg data directory

On 2014-01-07 21:54, Jeff Janes wrote: > On Tue, Jan 7, 2014 at 10:58 AM, > wrote: > - keep a copy "backup_label" under a different name [...[ > Why under a different name? That sounds dangerous to me. ... otherwise it would be useless, because "pg_stop_backup" will

[GENERAL] Consistent file-level backup of pg data directory

Hi, On my site, we run rsync-based backups of all servers to a central backup server every night. Unfortunately, reading the postgres documentation I could not find any direct way how to ensure that the state of the postgres data directory stored on the backup server is in a consistent state.