Обсуждение:

Hello,

We used postgres since 5 months, and we have some times crash, with the
following entry in the postgres.log:
 /usr/lib/postgresql/bin/postmaster: ServerLoop: select failed: No child
processes

Please help me...

Here some informations on the installation:
Debian 2.2.17
Postgres 7.0.3

Bests regards

Loic Courtois

=?iso-8859-1?Q?Lo=EFc_Courtois?= <lcourtois@netpartage.fr> writes:
> We used postgres since 5 months, and we have some times crash, with the
> following entry in the postgres.log:
>  /usr/lib/postgresql/bin/postmaster: ServerLoop: select failed: No child
> processes

This is a known bug: the SIGCHLD catcher in postmaster.c needs to save
and restore errno.  It's fixed in 7.1, or you can patch it yourself in
7.0.* --- see previous discussions in the archives.

            regards, tom lane