I suspect that PostgreSQL would log anything related to a network
connection problem if the error logging level was set correctly.
If you don't see any of those perhaps it is a networking issue. You
might need to try an ethernet capture tool like Wireshark or perhaps
something like tcpflow.
On Apr 26, 2007, at 4:26 AM, [EMAIL PROTECTED] wrote:
since we upgraded to the latest php and PostgreSQL - we started to
get frequent pg_connect() errors. What is sure is that they are not
caused by insufficient connections - PostgreSQL reports 100
connections available and less than 10 used when the pg_connect fails.
pg_last_error() and the other error handling functions operate on
connection. So they do not seem useful when pg_connect() fails.
In the PostgreSQL documentation I could find out how to log
successful connections, but not how to login failed connections.
Could somebody advice me on possible ways to test?
John DeSoi, Ph.D.
Power Tools for PostgreSQL
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php