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

hi

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"

i've tried to search in the pgsql list archives, but the i can't get the
search resuylt page due to a timeout (maybe mi isp connection :( )

i'm using redhat 6.2 and postgresql 7.2-1PGDG

thanks in advance and best regards

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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

> 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.

thanks a lot, certainly i've not touched the config files, just
installed and started, and haven't had the time to look at performance
tuning tips, once again applies the rtfm thing :)