max_connections not changing
От | Benjamin |
---|---|
Тема | max_connections not changing |
Дата | |
Msg-id | 4151713A.9000807@netyantra.com обсуждение исходный текст |
Список | 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. ------------------------------------------------------------------------------
В списке pgsql-novice по дате отправления: