Re: Changing max_connections without restart ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean Arnaud <Jean(dot)Arnaud(at)inrialpes(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Changing max_connections without restart ?
Date: 2006-08-25 17:55:20
Message-ID: 3393.1156528520@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jean Arnaud <Jean(dot)Arnaud(at)inrialpes(dot)fr> writes:
> I'm looking for a way to change the "max_connections" parameter without
> restarting the PostGreSQL database.

There is none. That's one of the parameters that determines shared
memory array sizes, and we can't change those on-the-fly.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message George Pavlov 2006-08-26 17:13:19 stats reset during pg_restore?
Previous Message Jean Arnaud 2006-08-25 16:57:08 Changing max_connections without restart ?