Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z4bSu-00047D-Ke for pgsql-docs@arkaria.postgresql.org; Mon, 15 Jun 2015 20:58:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z4bSu-0000b7-1T for pgsql-docs@arkaria.postgresql.org; Mon, 15 Jun 2015 20:58:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z4bSt-0000b0-71 for pgsql-docs@postgresql.org; Mon, 15 Jun 2015 20:58:43 +0000 Received: from [2600:3c02::f03c:91ff:fe70:c491] (helo=apinaye.timbira.com.br) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Z4bSp-0006Qp-OM for pgsql-docs@postgresql.org; Mon, 15 Jun 2015 20:58:42 +0000 Received: by apinaye.timbira.com.br (Postfix, from userid 110) id C19C311420; Mon, 15 Jun 2015 17:58:37 -0300 (BRT) X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on apinaye X-Spam-Level: X-Spam-Status: No, score=-100.2 required=5.0 tests=ALL_TRUSTED,BAYES_00, DNS_FROM_AHBL_RHSBL, URIBL_BLOCKED, USER_IN_WHITELIST autolearn=no version=3.3.1 Received: from [10.2.213.122] (unknown [137.122.64.35]) by apinaye.timbira.com.br (Postfix) with ESMTPSA id 6FCBA1141D; Mon, 15 Jun 2015 17:58:37 -0300 (BRT) Message-ID: <557F3C7C.2010802@timbira.com.br> Date: Mon, 15 Jun 2015 17:58:36 -0300 From: Euler Taveira Organization: Timbira User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.7.0 MIME-Version: 1.0 To: Jeff Janes , pgsql-docs@postgresql.org Subject: Re: "Alter system" command documentation References: In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2600:3c02::f03c:91ff:fe70:c491 (failed) X-Pg-Spam-Score: -1.1 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On 15-06-2015 13:32, Jeff Janes wrote: > From http://www.postgresql.org/docs/current/static/sql-altersystem.html > > "Values set with ALTER SYSTEM will be effective after the next server > configuration reload (SIGHUP or pg_ctl reload), or after the next server > restart in the case of parameters that can only be changed at server start." > > Isn't it unfortunate that the command used for changing the > configuration file from within SQL mentions SIGHUP and pg_ctl reload, > but not "select pg_reload_conf();", as a way to activate that change? > SIGHUP is an implementation detail. If I were to change that sentence, my preference is replace SIGHUP with pg_reload_conf. -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs