Re: [GENERAL] Corrupt Incrementally Updated Backup: missing pg_clog file

2012-11-05 Thread Albe Laurenz
Jeff Janes wrote: > On Wed, Oct 31, 2012 at 7:24 AM, Jürgen Fuchsberger > wrote: > > I have a problem with a corrupt backup, fortunately I was only testing so I > > did not loose any data. Unfortunetely what I did is to follow the backup > > guidelines in the documentation, which I thought should

Re: [GENERAL] Corrupt Incrementally Updated Backup: missing pg_clog file

2012-11-01 Thread Jeff Janes
On Wed, Oct 31, 2012 at 7:24 AM, Jürgen Fuchsberger wrote: > Hi all, > > I have a problem with a corrupt backup, fortunately I was only testing so I > did not loose any data. Unfortunetely what I did is to follow the backup > guidelines in the documentation, which I thought should work reliably. H

Re: [GENERAL] Corrupt Incrementally Updated Backup: missing pg_clog file

2012-11-01 Thread Ralf Schuchardt
Hi Jürgen, am 31.10.2012 um 15:24 schrieb Jürgen Fuchsberger : > The replica is backed up once a week using rsync, a full backup runs about 10 > hours, so I also keep at least 24h of WAL files to make sure I have a > consistent backup. > > The backup process also runs fine without errors, on

[GENERAL] Corrupt Incrementally Updated Backup: missing pg_clog file

2012-10-31 Thread Jürgen Fuchsberger
Hi all, I have a problem with a corrupt backup, fortunately I was only testing so I did not loose any data. Unfortunetely what I did is to follow the backup guidelines in the documentation, which I thought should work reliably. Here are the details: I am running a postgreSQL 8.4 database on