Skip site navigation (1) Skip section navigation (2)

Re: explaining "context" column of pg_settings

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: explaining "context" column of pg_settings
Date: 2010-12-18 03:00:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
On Thu, Dec 16, 2010 at 7:11 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Josh Kupershmidt <schmiddy(at)gmail(dot)com> writes:
> I did some work on this patch and attach an updated version.

Thanks for taking a look at this. Your version is much more clear.

> I'm not
> however convinced that it's a good idea to bury this material in
> catalogs.sgml --- I think few people ever read that chapter.  Shouldn't
> we put this into config.sgml instead, somewhere in section 18.1?

Yeah, that seems like a better place for this text.

>> I avoided just copy-pasting from guc.h, particulary because some of
>> the explanations struck me as confusing or incorrect.
> Well, your replacement explanations seemed even less correct ;-).
> Also, I think what the text needs to emphasize is *how* to change
> each setting type, so that prompted some of my editing.

One piece in my patch which isn't in your version is this bit:

+     ... You may also
+     send a <systemitem>SIGHUP</systemitem> to an individual backend to cause
+     only that backend to reload <filename>postgresql.conf</filename>.

I was rather surprised when I learned this from the description in
guc.h of SIGHUP options. I tested by altering "full_page_writes" in
postgresql.conf and sending a SIGHUP to one backend, and sure enough
that backend picked up the change but new backends didn't. Unless this
feature is documented somewhere else, I think it would be helpful to
keep a snippet like this.


In response to


pgsql-docs by date

Next:From: Robert HaasDate: 2010-12-18 03:45:32
Subject: Re: explaining "context" column of pg_settings
Previous:From: Euler Taveira de OliveiraDate: 2010-12-17 18:08:40
Subject: Re: explaining "context" column of pg_settings

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group