Обсуждение: 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@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 :)