Re: error modifying max_connections (maybe a little o.t.)

On Tue, Jul 23, 2002 at 07:00:03PM -0500, miguel angel rojas aquino wrote:

> i've recently began to test a java application with multiple
> simultaneous users, and began to get a "java.sql.SQLException: FATAL 1:
>   Sorry, too many clients already", so i figured out the problem could
> be solved changing the max_connections parameter in postgresql.conf from
> 32 to a bigger number, say 64, but when restarting postgresql it fails, in
> /var/log/messages all i can see is a "$Starting postgresql service:  failed"

You should look at your postgres logs, which will likely tell you
what the real problem is, and then read

http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/postmaster-start.html#POSTMASTER-START-FAILURES

(sorry bout the long line) and associated bits there.  It seems
likely that you haven't changed the configuration at all; you'll be
very unhappy with the performance that way.  You certainly want at
least a few thousand shared buffers, if nothing else.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110