Re: db sever seems to be dropping connections - Mailing list pgsql-general

From Chris
Subject Re: db sever seems to be dropping connections
Date
Msg-id 441E4275.5020803@gmail.com
Whole thread Raw
In response to db sever seems to be dropping connections  ("Rushabh Doshi" <rdoshi@vmware.com>)
Responses Re: db sever seems to be dropping connections  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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?

> 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?

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: Berend Tober
Date:
Subject: Re: How to idenity duplicate rows
Next
From: Chris
Date:
Subject: Re: Connecting