ivan <iv@psycho.pl> writes:
> the error is : could not fork new process for connection: Resource
> temporarily unavailable
We could have saved some time if you'd spelled out the full error
message to begin with.
This is undoubtedly a kernel-imposed restriction you are running into.
I'm not sure if the failure is related to sheer number of processes,
number of open files, or RAM/swap space, but one way or another you are
trying to create more processes than your kernel will support.
It seems moderately unlikely that twenty or thirty Postgres processes
would by themselves be able to run the kernel out of resources (although
if the problem is related to number of open files, reducing
max_files_per_process might help). What else do you have running on
this machine?
regards, tom lane