Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XZBxz-0003t4-3q for pgsql-admin@arkaria.postgresql.org; Wed, 01 Oct 2014 04:56:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XZBxy-0002hQ-Ey for pgsql-admin@arkaria.postgresql.org; Wed, 01 Oct 2014 04:56:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XZBxx-0002eu-4i for pgsql-admin@postgresql.org; Wed, 01 Oct 2014 04:56:41 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XZBxu-0000mK-1C for pgsql-admin@postgresql.org; Wed, 01 Oct 2014 04:56:39 +0000 Received: from [10.0.0.9] ([68.81.16.241]) by mail.gmx.com (mrgmx102) with ESMTPSA (Nemesis) id 0MOkQc-1XeAJZ1AGM-0067Sq; Wed, 01 Oct 2014 06:56:35 +0200 Message-ID: <1412139392.13055.2.camel@vanquo.pezone.net> Subject: Re: How to detect if Postgres needs a restart when configuration changes From: Peter Eisentraut To: Jason Mathis Cc: Ian Barwick , Strahinja =?UTF-8?Q?Kustudi=C4=87?= , "pgsql-admin@postgresql.org" Date: Wed, 01 Oct 2014 00:56:32 -0400 In-Reply-To: <7090DAD0-F2CA-4574-9CA0-BBDF6DD85A04@redzonesoftware.com> References: <542B48C5.6070507@2ndquadrant.com> <7090DAD0-F2CA-4574-9CA0-BBDF6DD85A04@redzonesoftware.com> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.8.5-2+b1 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:E1miIydOt5HbpzopfeAHa2aV/ffb6LxguLVOedP8lQnYe//9R7l s3ZOfq4rwG1dr9S50T/A8lVYBsm2FS6dPT2r2n1pq3XAOKxgbUa4A2i/+RD6FFdkQBJnGiG HPmF7qwtNGxh5uKGBBeShgRzU80GP2fUnogNQrgJcmJh3jMeEW0y9fpkq+24hOFysehOPjh TmJUVnmx3tStynsAnoHPA== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -2.8 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Tue, 2014-09-30 at 18:51 -0600, Jason Mathis wrote: > How are you automating? Have you looked at puppet or anything? Puppet > labs maintains a postgresql module that has all that baked in. Check > it out at least it can give you some ideas. Their "idea" is to maintain a hard-coded list about which parameter changes need a restart, and their list is wrong. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin