Skip site navigation (1) Skip section navigation (2)

Re: max_connections, solaris semaphores and initdb

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Isaac Vetter <ivetter(at)math(dot)purdue(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: max_connections, solaris semaphores and initdb
Date: 2008-01-11 18:55:51
Message-ID: 23303.1200077751@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: LWATCDRDate: 2008-01-11 18:58:23
Subject: Re: Connecting to the database server
Previous:From: Isaac VetterDate: 2008-01-11 17:08:27
Subject: max_connections, solaris semaphores and initdb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group