| From: | "Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)nz> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Disconnected Backends |
| Date: | 2000-12-30 17:28:16 |
| Message-ID: | 008b01c07285$e5a22700$0101a8c0@godzone.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Tom,
> "ipsql"? Did you mean psql? If not, I'm clueless what client software
> you are talking about.
No, ipsql is a Win32 application that is available from
http://www.zeos.dn.ua, it works really well other than this apparent
disconnect problem. I have also had the same problem using the Win32 ODBC
client and MS-Access.
> What does "netstat" show about the state of the connections? What is
> your client code exactly?
netstat still things the connections are ESTABLISHED, which is obviously why
the postmasters are still there. Re: the client, there is a newer version
which I will get. I haven't dug around in the code but is there any form of
inactivity timeout in the postmaster for remote connections ? It might be a
good solution if there was.
Glen.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Lang | 2000-12-30 18:41:51 | Re: MySQL and PostgreSQL speed compare |
| Previous Message | Vince Vielhaber | 2000-12-30 16:57:15 | Re: DBD::Pg |