Isaac Vetter <ivetter(at)math(dot)purdue(dot)edu> writes:
> I'm running postgresql 7.4 on Solaris 9 and want to increase the value
> of postgresql.conf's max_connections for an existing, running install.
> I've edited /etc/system to what I think are more appropriate, but
> definitely higher, values. Then I changed the value of max_connections
> to 768; however, by watching the pg_stat_activity view and the
> serverlog, connections are rejected when the number of connections
> approaches 200 (with the infamous: "FATAL: connection limit exceeded
> for non-superusers" error).
Um, did you restart the postmaster? This is a
can't-change-after-startup parameter.
regards, tom lane