Thread: Increase the number of concurrent connection
Dear sirs, how I have to modify postgresql.conf to increase the number of concurrent connection over the value 100 setted by by default? I tryied to modify this value but the server get an error and not start. My version is 8.2.5 on Linux Fedora 8. The PC has 2 GB ram and Celeron 2.8 processor. An example of postgresql.conf is welcome. Thank you D. Formenton
am Thu, dem 10.01.2008, um 9:12:27 +0100 mailte dfx folgendes: > Dear sirs, > > how I have to modify postgresql.conf to increase the number of concurrent > connection over the value 100 setted by by default? > > I tryied to modify this value but the server get an error and not start. What exactly have you tryied, and which exactly error-message you got? > An example of postgresql.conf is welcome. max_connections = 101 Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
I changed max_connection from 100 to 200 and stop the service. If I try to start again the service does no start. What is the max number of connections I can hope to obtain without recompile the kernel of Fedora 8? Thank you. Domenico Formenton A. Kretschmer wrote: > > am Thu, dem 10.01.2008, um 9:12:27 +0100 mailte dfx folgendes: >> Dear sirs, >> >> how I have to modify postgresql.conf to increase the number of concurrent >> connection over the value 100 setted by by default? >> >> I tryied to modify this value but the server get an error and not start. > > What exactly have you tryied, and which exactly error-message you got? > > >> An example of postgresql.conf is welcome. > > max_connections = 101 > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > -- View this message in context: http://www.nabble.com/Increase-the-number-of-concurrent-connection-tp14729529p14731155.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
You may not have issues such that upping the # of users may be
a) running you out of postgres allocations (see your documentation for details) ... increasing settings in the postgresql.conf file might help (shared_buffers for instance, and shared_buffers )
or
b) not enough shared memory configured so the restart fails; need to be "root" and increase the shmem settings and then restart PostgreSQL ...
HTH, sorry for top-posting but I have challenged mail client ...
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of dformenton
Sent: Thu 1/10/2008 4:14 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Increase the number of concurrent connection
I changed max_connection from 100 to 200 and stop the service.
If I try to start again the service does no start.
What is the max number of connections I can hope to obtain without recompile
the kernel of Fedora 8?
Thank you.
Domenico Formenton
A. Kretschmer wrote:
>
> am Thu, dem 10.01.2008, um 9:12:27 +0100 mailte dfx folgendes:
>> Dear sirs,
>>
>> how I have to modify postgresql.conf to increase the number of concurrent
>> connection over the value 100 setted by by default?
>>
>> I tryied to modify this value but the server get an error and not start.
>
> What exactly have you tryied, and which exactly error-message you got?
>
>
>> An example of postgresql.conf is welcome.
>
> max_connections = 101
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
--
View this message in context: http://www.nabble.com/Increase-the-number-of-concurrent-connection-tp14729529p14731155.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster