On Monday 03 February 2003 2:39 pm, you wrote: > > Anyone know if postgres has a connections limit by default? I see a > > connections limit in my conf file but it is commented out..Just curious > > what the default limit is, if any. > > 32, compile with --with-maxbackends=N, where N is your max. connection > number. > > Egon
Thanks for that Egon. I didn't read the OP properly. I thought it was asking how Postgresql handled STALE connections. The specific situation I have in mind is that inside my firewall's DMZ I have an Apache server running PHP. This PHP opens a persistant connection through the firewall to a postgresql service in another DMZ. If I reboot the firewall, the PHP connection is lost and to get my PHP working again I have to restart Apache (If anyone can suggest how I can either get round of automate this I'd appreciate it). How does Postgresql handle this? I would hope that it would notice the loss of the IP connection and close the link gracefully, and not just leave the connectino dangling. Can anyone confirm this? -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
