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

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 :)