Hello,
Thanks I did it also in addition to it i had to double the shared buffer
size.
It now seems to be working fine.
regards,
Rakesh P.
----- Original Message -----
From: "Andrew Biagioni" <andrew.biagioni@e-greek.net>
To: <pgsql-admin@postgresql.org>; "rakesh" <rakesh@cygnus.stpp.soft.net>
Sent: Tuesday, May 27, 2003 7:06 PM
Subject: Re: [ADMIN] Max number of client connections...
> 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.biagioni@e-greek.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@cygnus.stpp.soft.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@postgresql.org so that your
> >message can get through to the mailing list cleanly
> >
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster