Subject: Re: graceful reload
From: Vasiliy G Tolstov <v.tolstov@selfip.ru>
Reply-To: v.tolstov@selfip.ru
To: Greg Smith <greg@2ndquadrant.com>
Cc: Shoaib Mir <shoaibmir@gmail.com>, Anh Ky Huynh <xkyanh@gmail.com>,
	PostgreSQL Admin <pgsql-admin@postgresql.org>
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>
Content-Type: text/plain; charset="UTF-8"
Organization: Selfip.Ru
Date: Fri, 04 Jun 2010 10:07:12 +0400
Message-ID: <1275631632.28777.0.camel@work.selfip.ru>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

В Чтв, 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