From: | "Rushabh Doshi" <rdoshi(at)vmware(dot)com> |
---|---|
To: | "Chris" <dmagick(at)gmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: db sever seems to be dropping connections |
Date: | 2006-03-20 07:40:25 |
Message-ID: | 428B5EAB52D41B48BFE2D7D21C522D2B09D5C5@PA-EXCH01.vmware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rushabh Doshi wrote:
> I'm facing an issue with PostgreSQL .. The server seems to drop the
> connection to my script after a couple of hours (sometimes, not always).
>
> DBD::Pg::db selectrow_array failed: could not receive data from server:
> ....
> ....
> :server closed the connection unexpectedly.
Do you get a better error in the postgresql logs?
--- Unfortunately there's nothing in the postgresql logs.
> And in another scenario it failed with the message:
> DBD::Pg::db selectrow_array failed: could not receive data from server:
> Connection timed out
Sounds more like a network issue. How is the script connecting to
postgres? using a socket? Through tcpip?
--- Using tcpip. I've tried to re-establish connection in my script in case
of invalid handles or network issues. But this seems to be happening quite
often
From | Date | Subject | |
---|---|---|---|
Next Message | Dragan Matic | 2006-03-20 09:50:42 | vacuum full taking much longer than dump + restore? |
Previous Message | david.hoksza | 2006-03-20 07:02:15 | Re: ambuild parameters |