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

Konstantin Borchert wrote:
>
> dev(at)archonet(dot)com ("Richard Huxton") wrote in
> <20010424190204(dot)84D6D2A3AB(at)mainbox(dot)archonet(dot)com>:
>
> >Konstantin Borchert <borchert(at)antsatwork(dot)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(at)ntsp(dot)nec(dot)co(dot)jp \ \