On top of what Vivek said, you need to update your pg install. 7.4.2
had a few data eating bugs if I remember correctly. 7.4 branch is up
to 7.4.18, and those are a lot of bug fixes (2+ years) you're missing.
If one of those bugs eats your data, don't expect any sympathy.
-
On Sep 28, 2007, at 10:28 AM, Radhika S wrote:
20775 ?S 0:00 postgres: abc myDB [local] idle in
transaction
20776 ?S 0:00 postgres: abc myDB [local] idle
17509 ?S 0:06 postgres: abc myDB [local] VACUUM
waiting
24656 ?S 0:00
Hi -
This has been happening more recently. Our database hangs after a VACUUM
and is unresponsive when we come in next morning.
The vacuum job runs at 03:00 am daily.
The command is : /usr/local/pgsql/bin/vacuumdb --full -d DbName
Also, what exactly does this mean VACUUM waiting. Is there a rea
