From my understanding, postmaster.opts just tells you what the config
parameters are for the running database, and it's over-written upon each
restart of postmaster. You'll want to add the options to the script that
actually starts Postgres. On a RedHat system, take a look in
/etc/rc.d/init.d or /etc/init.d for a file called "postgres" and set the
OPTS line to "-N 256 -B 512". IE
OPTS="-N 256 -B 512"
At 12:14 PM 4/24/01, Konstantin Borchert wrote:
>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.
>
>I need help
>
>thx
>
>
>Konstantin
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly