How to increase number of connections to 7.2.1

On Mon, 2004-10-18 at 11:15, Edwin New wrote:

I have tried changing the value of max_connections in
Postgresql.conf. It was commented out (as are all other entries
except "tcpip_socket = true"). Setting it to any other value that the
default 32 resulted in the server failing to restart.

Without knowing the error message you got, it's possible that you didn't
increase shared_buffers to correspond to the newly increased
max_connections. If you increase shared_buffers, then you're probably
exceeding the system SysV shared memory restrictions. See

http://www.postgresql.org/docs/7.4/static/kernel-resources.html#SYSVIPC

-Neil

Edwin New <edwin_new@toll.com.au> writes:

I need to increase the number of connections to PostgreSQL 7.2.1.

I have tried changing the value of max_connections in
Postgresql.conf. It was commented out (as are all other entries
except "tcpip_socket = true"). Setting it to any other value that the
default 32 resulted in the server failing to restart.

1) Make sure your shared_buffers setting is big enough to handle your
desired connection limit.

2) Make sure your kernel's shared memory limits allow for your
shared_buffers setting.

If you can't get it to start, please post the server log entries from
the failed attempt--otherwise we have nothing to go on.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

What error do you get when the server fails to restart? It sounds like
it could be a kernel resource issue. See:

http://www.postgresql.org/docs/7.4/static/kernel-resources.html

-tfo

On Oct 17, 2004, at 8:15 PM, Edwin New wrote:

It was the shared buffers. Thanks to everyone for your quick and accurate
responses.

Regards,

Edwin.

-----Original Message-----
From: Doug McNaught [mailto:doug@mcnaught.org]
Sent: Monday, 18 October 2004 11:45 AM
To: Edwin New
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to increase number of connections to 7.2.1

Edwin New <edwin_new@toll.com.au> writes:

I need to increase the number of connections to PostgreSQL 7.2.1.

I have tried changing the value of max_connections in
Postgresql.conf. It was commented out (as are all other entries
except "tcpip_socket = true"). Setting it to any other value that the
default 32 resulted in the server failing to restart.

1) Make sure your shared_buffers setting is big enough to handle your
desired connection limit.

2) Make sure your kernel's shared memory limits allow for your
shared_buffers setting.

If you can't get it to start, please post the server log entries from
the failed attempt--otherwise we have nothing to go on.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863