Re: Re: Problem with postgreSQL (number of backends)

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                        \   \