Обсуждение: Postgresql problems

Hi,
I am a new user to postgresql. i am facing regarding
postgresql. Here are the problems:

1. Connection startup failed <fork failure> : Resource
temporarily unavailable
i had change the buffer to 700 and the maximum
connection to 300 in the postgresql.conf and i still
faced this problem after a few days. I tested only at
10 -15 pc a day. However, I didn't turn off the
postgresql server.
Its there any some sort of garbage collector that will
clear the resource when the connection is being turn
off?

2. How can i execute a script file from windows
platform at cygwin environment?

Hope that you can help. Thanks in advance.
Regards,
Lee


__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2

Lee Tuck <tuckkhai@yahoo.com> writes:
> 1. Connection startup failed <fork failure> : Resource
> temporarily unavailable

You probably need to increase your system's limit on the number of
processes per userid.  Postgres has to be able to start a process
for each connection received.  Just increasing max_connections in
postgresql.conf won't work if the kernel is not configured to allow it...

            regards, tom lane