Hi !

I'm looking for a way to change the "max_connections" parameter without
restarting the PostGreSQL database.
All the docs i found online are saying that this option can only be set
on startup (-N option to comand-line) or by changing it in postgresql.conf.

Does anyone know how to do it ?

Thanks

--
-- Jean Arnaud
-- Projet SARDES
-- INRIA Rhône-Alpes / LSR-IMAG
-- Tél. : +33 (0)4 76 61 52 80

Search Discussions

  • Tom Lane at Aug 25, 2006 at 5:55 pm

    Jean Arnaud 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedAug 25, '06 at 4:55p
activeAug 25, '06 at 5:55p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Jean Arnaud: 1 post Tom Lane: 1 post

People

Translate

site design / logo © 2022 Grokbase