Обсуждение: max_connections not changing

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.

Any ideas, as to where i am going wrong?
Also, is there any command line facility to check the system's
configuration specific values., ie the values being used currently,
isntead of the postgresql.cong file?

Any help appreciated.

Thanx.

--

Benjamin Jacob.

Disclaimer :
------------------------------------------------------------------------------
If you are not the intended recipient of this transmission to whom it is
addressed, or have received this transmission in error, you are hereby
notified that any dissemination, distribution or copying of this transmission
is strictly prohibited. Please notify us immediately and delete this e-mail
from your system. The sender does not accept liability for any errors or
omissions in the contents of this message which arise as a result of e-mail
transmission, which cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, arrive at wrong address or contain viruses. If verification
is required please request a hard-copy version.  This e-mail contains only the
personal opinions of the sender and does not represent an official
communication from NetYantra of any manner.
------------------------------------------------------------------------------

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

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

>> Tho shared buffers value, duz change as said to 80, but theres no change
>> in the max connections value.

I'm not sure that pg_ctl is bright enough to handle multiple -o options.
You might need -o "-N 40 -B 80" instead.

Having said that, though, I think there is little or no good use for -o
in the first place.  It's better to set the values you want in
postgresql.conf.

BTW, -B 80 is ridiculously low.  It may run, but performance will be
terrible.

            regards, tom lane