Re: Max number of client connections...

From: Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)net>
To: pgsql-admin(at)postgresql(dot)org, "rakesh" <rakesh(at)cygnus(dot)stpp(dot)soft(dot)net>
Subject: Re: Max number of client connections...
Date: 2003-05-27 13:36:58
Message-ID: 1X2VEDYTTPJFJLJSM0567XSVRTN4Z.3ed369fa@Laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

THe way the .conf file is structured is, that each option is commented out when
its default value applies, but the default value is the value shown for the
option in the .conf file -- so it would be the same if you un-commented the
line.

To change the value, you un-comment the line and change the value for the
parameter in that line.

I don't have a 7.1 postgresql.conf file handy, so I can't give you an exact
example, but if you currently have:

#max_connections = xx

then the default is xx maximum connections. To set the maximum to yy, change
the line to:

max_connections = yy

Otherwise you can do as I do, and leave the commented-out line and follow it
with a comment and a new line:

#max_connections = xx
# Added andrew(dot)biagioni(at)e-greek(dot)net on 5/5/2002:
max_connections = yy

This allows me to keep a reminder of what the default was, which is what I
would have if I removed MY line.

Happy PostgreSQLing,

Andrew

5/27/03 2:14:24 AM, "rakesh" <rakesh(at)cygnus(dot)stpp(dot)soft(dot)net> wrote:

>Hello Everybody,
>
>I'm new to this list. My postgresql 7.1 (RHL -7.2& server does not respond
>when quiet some connections
>are made. Do I need to change the max_connections option in postgresql.conf,
>but surprisingly it is commented.
>
>In this case what is the default number of connections to which it can
>respond? And also if i need to increase the number of connections what do i
>need to do?
>
>Help appreciated !!!
>
>regards,
>
>Rakesh Pawar.
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2003-05-27 14:01:03 OIDs
Previous Message David A. Leedom 2003-05-27 13:36:05 Re: Postgress