Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: brewDate: 2004-09-22 15:00:27
Subject: Re: Multi Database queries
Previous:From: Joe ConwayDate: 2004-09-22 03:48:49
Subject: Re: Multi Database queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group