Re: How to delete unclosed connections? - Mailing 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.