X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6776A9FBB93 for ; Fri, 25 Aug 2006 13:55:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 96200-06 for ; Fri, 25 Aug 2006 16:54:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx-serv.inrialpes.fr (mx-serv.inrialpes.fr [194.199.18.100]) by postgresql.org (Postfix) with ESMTP id 94A089FBB6C for ; Fri, 25 Aug 2006 13:54:53 -0300 (ADT) Received: from vilnius.inrialpes.fr (vilnius.inrialpes.fr [194.199.18.81]) by mx-serv.inrialpes.fr (8.13.6/8.13.0) with ESMTP id k7PGsmYp000425 for ; Fri, 25 Aug 2006 18:54:48 +0200 (MEST) Received: from [194.199.25.12] (magnesium.inrialpes.fr [194.199.25.12]) by vilnius.inrialpes.fr (8.13.6/8.11.3/ImagV2) with ESMTP id k7PGsl0v027434 for ; Fri, 25 Aug 2006 18:54:47 +0200 (MEST) Message-ID: <44EF2BE4.5050301@inrialpes.fr> Date: Fri, 25 Aug 2006 18:57:08 +0200 From: Jean Arnaud User-Agent: Mozilla Thunderbird 1.0.7-1.1.fc4 (X11/20050929) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Changing max_connections without restart ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (mx-serv.inrialpes.fr [194.199.18.100]); Fri, 25 Aug 2006 18:54:48 +0200 (MEST) X-mx-serv-inrialpes-fr-MailScanner-Information: Please contact postmaster@inrialpes.fr for more information X-mx-serv-inrialpes-fr-MailScanner: Found to be clean X-mx-serv-inrialpes-fr-MailScanner-SpamCheck: n'est pas un polluriel, SpamAssassin (score=0, requis 6) X-mx-serv-inrialpes-fr-MailScanner-From: jean.arnaud@inrialpes.fr X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/408 X-Sequence-Number: 20593 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