Обсуждение: Vacuum and deadlock.
Since some week I have some trouble with my database. I use postgres v 7.1.2 on redhat 7.0
The trouble is that the database lock when in the night some user left an application open ( which do some read on some table) and the night process of backup and vacuum happend.
The database stay in a deadlock until I restart it manually on the morning.
At the moment I've told the users to stop their application but it's not really a solution.
Does someone have any idea ?
Thanks
On Wednesday, September 5, 2001, at 07:11 AM, Sébastien HEITZMANN wrote: > Since some week I have some trouble with my database. I use postgres v > 7.1.2 on redhat 7.0 > > The trouble is that the database lock when in the night some user left > an application open ( which do some read on some table) and the night > process of backup and vacuum happend. > The database stay in a deadlock until I restart it manually on the > morning. Why don't you just kill all the connections before running vacuum? Jeremy Buchmann [jeremy@wellsgaming.com]