Thread: Bug #527: server hangs up and refuses any connection

Alla El Gohary (allaelgohary@bftech.com.eg) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
server hangs up and refuses any connection

Long Description
dear pgsql-bugs
i'm running postgresql 7.1.2 on freebsd4.3 my application consists of several components running on win32s clients some
ofthe modules interact with each other on the network using udp and tcp packets i have nearly 14 clients running on the
serveri mentioned before on a workgroup network using a 3com 10/100 switch 
while the traffic is high i mean all the clients are interacting together the server hangs up and all the connections
tothe server stops 
even pinging doesn't reply.
at first i switched to freebsd 3.1 i thought its something related to freebsd but again the same thing happened but
thistime a message poped up on the server 
"sdec kernel table full" and the server hang up
when i restart the server everything comes back to normal
i'm connecting to the server from the win32s clients through postgresql ODBC driver v7
i run the postmaster using /usr/local/pgsql/bin/postmaster -i -S -o -F
please if there's a solution to that reply me back ASAP


Sample Code


No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> "sdec kernel table full" and the server hang up

Sounds to me like you're running out of kernel file-table slots or some
such.  Please read the Postgres documentation on configuring kernel
resources.

            regards, tom lane