Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing max_connections without restart ? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Changing max_connections without restart ?
Date
Msg-id 3393.1156528520@sss.pgh.pa.us
Whole thread Raw
In response to Changing max_connections without restart ?  (Jean Arnaud <Jean.Arnaud@inrialpes.fr>)
List pgsql-performance
Tree view 
Jean Arnaud <Jean.Arnaud@inrialpes.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

pgsql-performance by date:

Previous
From: Jean Arnaud
Date:
Subject: Changing max_connections without restart ?
Next
From: "George Pavlov"
Date:
Subject: stats reset during pg_restore?