| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Edwin New <edwin_new(at)toll(dot)com(dot)au> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to increase number of connections to 7.2.1 |
| Date: | 2004-10-18 01:45:00 |
| Message-ID: | 1098063900.22986.120.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2004-10-18 01:45:19 | Re: How to increase number of connections to 7.2.1 |
| Previous Message | Edwin New | 2004-10-18 01:15:48 | How to increase number of connections to 7.2.1 |