Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 03B2A476E5A; Mon, 13 Jan 2003 16:01:58 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id C34F24770AF; Mon, 13 Jan 2003 16:01:09 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0DL1A5u005808; Mon, 13 Jan 2003 16:01:10 -0500 (EST) To: "Thomas F.O'Connell" Cc: pgsql-docs@postgresql.org, pgsql-general@postgresql.org Subject: Re: GUC/postgresql.conf docs In-reply-to: <3B03D006-2734-11D7-AD8E-00306596B4E8@monsterlabs.com> References: <3B03D006-2734-11D7-AD8E-00306596B4E8@monsterlabs.com> Comments: In-reply-to "Thomas F.O'Connell" message dated "Mon, 13 Jan 2003 14:18:51 -0600" Date: Mon, 13 Jan 2003 16:01:10 -0500 Message-ID: <5807.1042491670@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/25 X-Sequence-Number: 1625 "Thomas F.O'Connell" writes: > I just wanted to make sure the list was exhaustive. What of those that > are marked "startup or postgresql.conf"? I believe the latter are the ones you cannot set per-backend. If you want to be certain, look through src/backend/utils/misc/guc.c to see which variables are marked PGC_POSTMASTER. Those are the restart-required vars. The ones marked PGC_SIGHUP can be changed from postgresql.conf, but not per-backend. (See comments in src/include/utils/guc.h for the gory details.) If you find any for which the Admin Guide is wrong or misleading, please submit a docs patch ... regards, tom lane