Konstantin Borchert wrote:
>
> dev@archonet.com ("Richard Huxton") wrote in
> <20010424190204.84D6D2A3AB@mainbox.archonet.com>:
>
> >Konstantin Borchert <borchert@antsatwork.de> said:
> >
> >> Hi,
> >>
> >> i have problems with PostgreSQL 7.0.3 on a RedHat 6.2 System. Very
> >> often postgresql post me the following warning and error message.
> >>
> >>
> >> Warning: Unable to connect to PostgreSQL server: Sorry, too many
> >> clients already in /home/server/...
> >> PostgreSQL said: Unable to connect to server
> >>
> >>
> >> It seems to be a problem with buffers and backends. So i have restart
> >> the postmaster with the parameters "/usr/bin/postmaster -N 256 -B 512
> >> " ... (i put these parameters in the file "postmaster.opts" in the
> >> postgresql data folder).But it seems to have no effect. The problem
> >> still exist.
> >
> >How many clients do you have when this happens?
>
> no more than 32 clients
>
> >How much RAM have you got?
>
> the server has 256 MB RAM
>
> >Did you alter the max_connections setting at install time?
>
> no, i use the default values
> it's possible to change the value of max_connections??
Why not try to edit the
/var/lib/pgsql/data/postmaster.opts.default
file
and place this inside..;-)
-i -N 256 -B 4096 -o "-S 4096 -F"
run the following:
echo 16384 > /proc/sys/fs/file-max
echo 134217728 > /proc/sys/kernel/shmmax
and restart your database server...
/etc/rc.d/init.d/postgresql restart
That should make your box a little happy...;-)
--
/) John Clark Naldoza y Lopez (\
/ ) Software Design Engineer II ( \
_( (_ _ Web-Application Development _) )_
(((\ \> /_> Cable Modem Network Management System <_\ </ /)))
(\\\\ \_/ / NEC Telecom Software Phils., Inc. \ \_/ ////)
\ / \ /
\ _/ phone: (+63 32) 233-9142 loc. 3112 \_ /
/ / cellphone: (+63 919) 399-4742 \ \
/ / email: njclark@ntsp.nec.co.jp \ \