[ADMIN] vacuumdb not enough stack items

2008-06-21 Thread hjeancha
Hi, i use postgresql version7.4.7 on i386-pc-linux-gnu, autovacuum is configured to run on this database. But recently, we lost data for a database, we were able to connect the database but we couldn't see any table anymore. I suspected a transaction ID wraparound, and to fix it, i just imp

Re: [ADMIN] vacuumdb not enough stack items

2008-06-22 Thread hjeancha
Tom Lane <[EMAIL PROTECTED]> a écrit : [EMAIL PROTECTED] writes: i use postgresql version7.4.7 on i386-pc-linux-gnu, autovacuum is configured to run on this database. Hmm ... in theory autovacuum should have kept you out of trouble, if it was working properly. Were you keeping an eye on its

Re: [ADMIN] vacuumdb not enough stack items

2008-06-23 Thread hjeancha
Decibel! <[EMAIL PROTECTED]> a écrit : On Jun 21, 2008, at 8:47 AM, [EMAIL PROTECTED] wrote: i use postgresql version7.4.7 on i386-pc-linux-gnu, autovacuum is configured to run on this database. But recently, we lost data for a database, we were able to connect the database but we couldn't