Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7CB9165022F for ; Wed, 31 Dec 2008 09:05:48 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62703-05-3 for ; Wed, 31 Dec 2008 09:05:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by mail.postgresql.org (Postfix) with ESMTP id 5E9F96500AC for ; Wed, 31 Dec 2008 09:05:37 -0400 (AST) Received: from [192.168.10.64] (ASte-Genev-Bois-153-1-97-136.w86-218.abo.wanadoo.fr [86.218.123.136]) by sd-2317.dedibox.fr (Postfix) with ESMTP id EF6F61CA2; Wed, 31 Dec 2008 14:05:35 +0100 (CET) Message-ID: <495B6E1F.50508@lelarge.info> Date: Wed, 31 Dec 2008 14:05:35 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.18 (X11/20081125) MIME-Version: 1.0 To: Jaume Sabater CC: pgsql-admin@postgresql.org Subject: Re: Getting the value of a config parameter in runtime References: <3786f7bb0812310335p7d1e5bbu8d01b175a628ee6f@mail.gmail.com> In-Reply-To: <3786f7bb0812310335p7d1e5bbu8d01b175a628ee6f@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/210 X-Sequence-Number: 31043 Jaume Sabater a écrit : > [...] > Sorry to ask this, I had it noted down but now I cannot find it and > I've been googling for 30 minutes now without success. There is a way > to query the system database to get the current value of a > configuration parameter, something in the form of SELECT value FROM > some_table WHERE field_name = 'archive_command', or similar, can't > remember, honestly. Or perhaps something more generic which was > filtered with greps, tails, heads and cuts. > > Would someone be so kind as to point me at the right page or remind me > the way it was done? > Table is pg_settings, and your field_name should be name. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com