From: Vasiliy G Tolstov <v.tolstov@selfip.ru>
To: Greg Smith <greg@2ndquadrant.com>
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: Fri, 04 Jun 2010 10:07:12 +0400
Message-ID: <1275631632.28777.0.camel@work.selfip.ru> (raw)
In-Reply-To: <4C07E137.1070400@2ndquadrant.com>
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>
<4C07E137.1070400@2ndquadrant.com>
В Чтв, 03/06/2010 в 13:07 -0400, Greg Smith пишет:
> 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.
>
Ok, Thank You very much! This is really helpful.
--
Vasiliy G Tolstov <v.tolstov@selfip.ru>
Selfip.Ru
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: v.tolstov@selfip.ru, greg@2ndquadrant.com, shoaibmir@gmail.com, xkyanh@gmail.com
Subject: Re: graceful reload
In-Reply-To: <1275631632.28777.0.camel@work.selfip.ru>
* 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