postgresql and sockets

["Krzysztof Duleba" <krzysan at skrzynka dot pl>]

Hi

I am using Cygwin postgresql as my db engine for high load jboss/Hibernate
web app. It works fine, but after some 10k transactions socket seems
broken and I get this message:

$ psql
psql: could not connect to server: Bad file descriptor
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

$ cat /tmp/.s.PGSQL.5432
!<socket >1304 s D872D6B4-84B51718-5811C571-3E0793C6

However, `psql -h localhost -p 5432' succeeds. So in fact the socket is
still there, but the link stored in /tmp/.s.PGSQL.5432 is broken.

If I restart postmaster service, psql works again. Now /tmp/.s.PGSQL.5432
has different content:

$ cat /tmp/.s.PGSQL.5432
!<socket >1661 s A50B48C0-681AB839-08CFE772-54D105A7

I use the default postgresql.conf, only the following line was changed:
tcpip_socket = true

Any ideas is the problem related to Cygwin? If yes then I will try to
provide more info. I know it's not too specific, but a month ago
postgresql worked more stable (it wasn't as loaded as it is now though).

Regards
Krzysztof Duleba

Attachment: cygcheck.out
Description: Binary data

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/