Re: db sever seems to be dropping connections

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