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]