From: Greg Smith <greg@2ndquadrant.com>
To: v.tolstov@selfip.ru
Cc: Shoaib Mir <shoaibmir@gmail.com>
Cc: Anh Ky Huynh <xkyanh@gmail.com>
Cc: PostgreSQL Admin <pgsql-admin@postgresql.org>
Subject: Re: graceful reload
Date: Thu, 03 Jun 2010 13:07:03 -0400
Message-ID: <4C07E137.1070400@2ndquadrant.com> (raw)
In-Reply-To: <1275552074.23110.7.camel@work.selfip.ru>
References: <1275546216.6693.2.camel@work.selfip.ru>
<20100603144528.2234301e@icy.localdomain>
<1275551303.23110.1.camel@work.selfip.ru>
<AANLkTimZnrPMgeo_Wdy8lLnH5PmWiZnbuu7bIwKqefx2@mail.gmail.com>
<1275552074.23110.7.camel@work.selfip.ru>
Vasiliy G Tolstov wrote:
> In config file some in of this settings exists comment line like
> "changes require restart". This is mean exactly restart or reload can do
> this?
>
Run this:
$ psql -c "select name,context from pg_settings"
This will sort out which settings are in which category definitively,
rather than relying on the sometimes ambiguous comments in the file.
Settings that say "postmaster" require a full database restart. Ones
labeled "sighup" can be changed in the postgresql.conf and then the
server signaled to use them, most easily with:
pg_ctl reload
-OR-
psql -c "select pg_reload_conf()"
Ones labeled "user" you can actually change for any user at any time
during their session. Modifying the defaults and then executing the
sighup procedure will make those new defaults active, but not for any
clients that already have open connections.
I recommend using SHOW or looking at pg_settings after making a change
and reloading the server config to confirm it took.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@2ndquadrant.com, v.tolstov@selfip.ru, shoaibmir@gmail.com, xkyanh@gmail.com
Subject: Re: graceful reload
In-Reply-To: <4C07E137.1070400@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox