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/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
