Re: How to delete unclosed connections?

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "'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 14:44:04
Message-ID: 001901c38e73$ca35e9e0$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2003-10-09 14:52:06 Re: int1?
Previous Message Thierry Missimilly 2003-10-09 14:42:18 Postgres 7.4 : ECPG not Thread-safe