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

2014-01-10 Thread Jeff Janes
On Fri, Jan 10, 2014 at 9:03 AM, wrote: > 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. >> >

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

2014-01-10 Thread gator_ml
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

2014-01-10 Thread M Tarkeshwar Rao
Hi All, I am facing one problem. I want to read the log files of postgres. Actually our customer facing some problem in database. Continuously one error exception raised by the system. Error is: 2014-01-09 22:08:12.003, SEVERE, manager.Data Manager - Could not execute JDBC batch update; SQL [

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

2014-01-10 Thread Ivan Voras
On 08/01/2014 16:09, gator...@yahoo.de wrote: > For machines running database systems, this means, this means, > that I need some way to get a consistent state of some point in > time. It does not particularly matter, which time exactly (in > Unfortunately, it does not look like there is any dire

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

2014-01-08 Thread Jeff Janes
On Wed, Jan 8, 2014 at 7:09 AM, wrote: > 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. > ... otherw

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

2014-01-08 Thread gator_ml
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

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

2014-01-07 Thread Rajeev rastogi
On 08 January 2014, Gator wrote: > 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 t

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

2014-01-07 Thread Jeff Janes
On Tue, Jan 7, 2014 at 10:58 AM, wrote: > 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 store

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

2014-01-07 Thread gator_ml
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.