| From: | Jeremy Buchmann <jeremy(at)wellsgaming(dot)com> |
|---|---|
| To: | Sébastien HEITZMANN <2le(at)2le(dot)net> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Vacuum and deadlock. |
| Date: | 2001-09-06 16:22:29 |
| Message-ID: | 200109061621.JAA08358@mail.greatbasin.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)wellsgaming(dot)com]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-09-06 16:56:31 | Re: Need help or advices : databases and tables invisibles and not accessibles ! |
| Previous Message | Dong Calmada | 2001-09-06 15:08:08 | 'create view' error |