Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9609064FCC0 for ; Wed, 31 Dec 2008 07:35:55 -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 46592-09 for ; Wed, 31 Dec 2008 07:35:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f19.google.com (mail-bw0-f19.google.com [209.85.218.19]) by mail.postgresql.org (Postfix) with ESMTP id 4D52864FC53 for ; Wed, 31 Dec 2008 07:35:52 -0400 (AST) Received: by bwz12 with SMTP id 12so15220672bwz.19 for ; Wed, 31 Dec 2008 03:35:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=cY7IL/nMiqXnIaDQS7mm6RYcyjjMM0qPccn3eHBO6Ag=; b=nd/UpF8SsSbpOir3Fr5M+QaoWM2i667HZHK57vNlOcARLzpfyvyaq0e7bORjyXIppf 4pIZF4edfqfH9QyvdkZixQsb7KRkbDDtAW1gytKR9D+En/BmpzChVLLPqp2iopsBv2Ub tP7Sxb6tgKkXMPt1yO4Dd1dehSQ29rWReAJdU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=Lc/VaP658XLBTcpOLswci+hMauyXaTaLV8K7K3HfjKnVfW15OLQXvX3bZ8Dmlfui7t QlvxIM3WtrIPtx9j3mpaJq2NA2pfGH3hp/dZDaNIxnT9OSjlPkEyXd/bBMA/tjXvIPq6 Tj+Mm2JjhWLMv5ddq85iSV6ejG2mM4/NPZCIQ= Received: by 10.103.171.6 with SMTP id y6mr5665142muo.110.1230723349798; Wed, 31 Dec 2008 03:35:49 -0800 (PST) Received: by 10.103.165.9 with HTTP; Wed, 31 Dec 2008 03:35:49 -0800 (PST) Message-ID: <3786f7bb0812310335p7d1e5bbu8d01b175a628ee6f@mail.gmail.com> Date: Wed, 31 Dec 2008 12:35:49 +0100 From: "Jaume Sabater" To: pgsql-admin@postgresql.org Subject: Getting the value of a config parameter in runtime MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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/208 X-Sequence-Number: 31041 Hi all! 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? Thanks in advance. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas"