Re: max_connections not changing

On 2004-09-22, Benjamin <benjamin(at)netyantra(dot)com> wrote:
>
> Hello there,
>
> I want to increase the max_connections value from its default value of 32.
>
> I am trying to start postmaster with the following command
> ../bin/pg_ctl start -s -w -o -i -D ../data -o "-N 40" -o "-B 80"
> OR
> ../bin/pg_ctl start -s -w -o -i -D ../data -o "-c MAX_CONNECTIONS=40" -o
> "-c SHARED_BUFFERS=80"
>
> I check for the altered values, thru the pg_settings table.
> Tho shared buffers value, duz change as said to 80, but theres no change
> in the max connections value. I tried removing the max_connections line
> in the postgresql.cong file, and then retrying, but naah.. dint work.

Try this alternative interface:

show max_connections;

> Any ideas, as to where i am going wrong?

The above values look right, I would try:
- Checking the postgres log file (if enabled) for related messages. I would seem possible
that some OS-level issue could be preventing the max connections
from being raised.

- Be sure you are starting the server you think you are. (Maybe you have more
than one Postgres install and have gotten them confused?).

Mark