Re: How to delete unclosed connections?

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Együd Csaba <csegyud(at)vnet(dot)hu>
Cc: "'Pgsql-General(at)Postgresql(dot)Org (E-mail)'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to delete unclosed connections?
Date: 2003-10-09 15:00:49
Message-ID: Pine.LNX.4.33.0310090900170.15991-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 9 Oct 2003, [Windows-1252] Együd Csaba wrote:

> Hi Andrew,
> > Oh? pg_ctl -m f stop or pg_ctl -m i stop doesn't work?
> Aha, I'll try it.
>
> > Find the pid and kill -2 will work.
> To tell the truth I do not like to kill a database backend. It can lead many
> problems. I prefer indulgent methods instead, you know.
> It'll be the ultimate solution.

Only for your applications. Postgresql survives this kind of thing quite
well, with no data corruption, trust me, I've tested that part thourougly
lately.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-10-09 15:02:16 Re: PL/PGSQL for permutations?
Previous Message Stephan Szabo 2003-10-09 14:59:55 Re: int1?