max_connections not changing

From: Benjamin <benjamin(at)netyantra(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: max_connections not changing
Date: 2004-09-22 12:34:02
Message-ID: 4151713A.9000807@netyantra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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.
------------------------------------------------------------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message brew 2004-09-22 15:00:27 Re: Multi Database queries
Previous Message Joe Conway 2004-09-22 03:48:49 Re: Multi Database queries