Something's funny here. Unless you built a backend with
an override on the default max backend count,
you should be able to create no more than 32 backend
processes. Which is possible also if you installed an RPM
version and it's built for more than 32. Otherwise you should see
the message "Sorry, too many clients already" when making the
excess connections.
Could you provide the PostgresSQL version number? Also it
would help if you captured stdout and stderr and forwarded
them. Assuming you're using the Red Hat Control Panel to start
and stop the server, look at the postgres script in /etc/rc.d/init.d
You should see something like:
su postgres -c "postmaster -i -D /var/lib/pgsql"
Save the old version and change to
su postgres -c "postmaster -i -D /var/lib/pgsql >/var/lib/pgsql/pg.stdout
>&/var lib/pgsql/pg.stderr"
Then start up the system, shut it down. Revert to the old
startup script and send the pg.stdout and pg.stderr files.
regards,
Tim Holloway
Lucio Andres Perez wrote:
>
> Hi everyone,
>
> Maybe this could be a newbie trouble for somebody, but Iīve tried all I
> can and I havenīt found the source of my problem...
>
> I have a PII-400Mhz 192Mb RedHat 5.2 ( I know, itīs a little old )
> running only postgresql 6.4, the apache/php servers are running in other
> host.
>
> the problem is this: I start the postmaster whith the command
> "postmaster -i -B 256 - S" and it begins to create child process so
> that, when there are more than 30 process, the system is coming down,
> with 'segmentation fault' error messages, of course, Iīve to wait for
> a while, then I do a 'ps aux' to see what is going on, and I see all
> the process in ZOMBIE status !! and the memory is almost full, So Iīve
> to kill all these processes and restart the postmaster...
>
> How do I tune the postmaster so that it canīt use all the systemīs
> memory or at least, it can stand for more load. (in this case, load
> means a lot of simultaneous conexions)
>
> Please, I thank anything you can say me ...
>
> --
> Eng. Lucio Andres Perez
> NewMedia Director
> Telesat S.A.
> Cali-Colombia-SouthAmerica
> http://www.telesat.com.co
>
> ************
************
