X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3FDFC9FA3A6 for ; Mon, 8 May 2006 09:31:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 21912-01 for ; Mon, 8 May 2006 09:31:24 -0300 (ADT) X-Greylist: delayed 02:22:00.060272 by SQLgrey- Received: from as1.cineca.com (as1.cineca.com [130.186.84.251]) by postgresql.org (Postfix) with ESMTP id C1C629F96B6 for ; Mon, 8 May 2006 09:31:23 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by as1.cineca.com (Postfix) with ESMTP id 72919714A9; Mon, 8 May 2006 14:31:21 +0200 (CEST) Received: from cineca.mm.cineca.it (cineca.mm.cineca.it [130.186.10.200]) by as1.cineca.com (Postfix) with ESMTP id 7E3EB7149A; Mon, 8 May 2006 14:31:20 +0200 (CEST) Received: from [130.186.7.26] (dhcp7-26.cineca.it [130.186.7.26]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) as user f.dallaca@cineca.it by cineca.mm.cineca.it (Postfix) with ESMTP id 70090599D7D; Mon, 8 May 2006 14:31:20 +0200 (MEST) Message-ID: <445F3A18.8020005@cineca.it> From: Francesco Dalla Ca' Organization: CINECA User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20060202 Fedora/1.7.12-1.5.2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Meaning of contexts from pg_settings view Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Date: Mon, 8 May 2006 14:31:20 +0200 (MEST) X-Virus-Scanned: Cineca AppOs 0.85 at as1.cineca.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/67 X-Sequence-Number: 21599 The following query, give six differents kind of context presents on the system view pg_settings, that list all postgresql current parameters setting. postgres=# select distinct context from pg_settings; context ------------ backend internal postmaster sighup superuser user (6 rows) What's the mean for 'backend', 'postmaster' and 'sighup' context of a parameter? How i can know if a parameter is modifiable only with a server restart, rather than a 'pg_ctl reload' (sighup?) or a "SET/ALTER USER/ALTER DATABASE" command? Best regards, Francesco. -- -------------------------------------------------- Francesco Dalla Ca' Settore Gestione Sistemi CINECA Via Magnanelli 6/3 40033 Casalecchio di Reno (BO) Bologna, Italy http://www.cineca.it --------------------------------------------------