Re: How to delete unclosed connections? - Mailing list pgsql-general

From Együd Csaba
Subject Re: How to delete unclosed connections?
Date
Msg-id 001901c38e73$ca35e9e0$230a0a0a@compaq
Whole thread Raw
In response to Re: How to delete unclosed connections?  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: How to delete unclosed connections?
List pgsql-general
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.

> It will, once the TCP/IP timeout happens.  That's about 2 hours on many
systems.
I see, it sholud be waited for...

Thank you very much Anderw!

Best Regrds,
-- Együd Csaba

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 2003. 09. 29.



pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: Humor me: Postgresql vs. MySql (esp. licensing)
Next
From: Jonathan Bartlett
Date:
Subject: Re: Humor me: Postgresql vs. MySql (esp. licensing)