Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XZBwY-0003m4-LI for pgsql-admin@arkaria.postgresql.org; Wed, 01 Oct 2014 04:55:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XZBwX-0001Pq-9u for pgsql-admin@arkaria.postgresql.org; Wed, 01 Oct 2014 04:55:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XZBwV-0001Oi-8Y for pgsql-admin@postgresql.org; Wed, 01 Oct 2014 04:55:11 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XZBwS-0007Sb-1d for pgsql-admin@postgresql.org; Wed, 01 Oct 2014 04:55:10 +0000 Received: from [10.0.0.9] ([68.81.16.241]) by mail.gmx.com (mrgmx102) with ESMTPSA (Nemesis) id 0MVayZ-1XkaDV0E19-00Yxpo; Wed, 01 Oct 2014 06:55:06 +0200 Message-ID: <1412139303.13055.0.camel@vanquo.pezone.net> Subject: Re: How to detect if Postgres needs a restart when configuration changes From: Peter Eisentraut To: Strahinja =?UTF-8?Q?Kustudi=C4=87?= Cc: "pgsql-admin@postgresql.org" Date: Wed, 01 Oct 2014 00:55:03 -0400 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.8.5-2+b1 Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K0:vB+LDPpdacZGHQEJNi2gqI/BdV1KXhiKMULBNYgkW681XySVuGD yIiXYdlR7YsI+xFGbGWsf3TfcnTcCSQ3FJh85WoGFWzzfKeR4v1wviiUgbezwqARZcJW738 5zsNCezrJyVbDOpwCc0Ze9pf72B+3LAjIzIOMrcIjFUs35BID6Cc0V5jqi9bmZPDCZfB6UD VW/O7hO907PTLHc0EkKIw== 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 Wed, 2014-10-01 at 01:51 +0200, Strahinja Kustudi=C4=87 wrote: > I am automating Postgres deployment on Linux and I need to check if > Postgres needs to be restarted when a configuration parameter that > requires a restart changes, e.g. when you change wal_level. Is there a > way to detect a parameter which requires a restart was changed? As you can gather, there isn't really a straightforward way. But it would be a great feature addition. --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin