Re: max_connections not changing

On 2004-09-22, Benjamin <benjamin@netyantra.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