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 [[EMAIL PROTECTED]]
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
