X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A55BE5282B for ; Tue, 21 Jun 2005 21:50:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56815-10 for ; Wed, 22 Jun 2005 00:50:41 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id 310465288E for ; Tue, 21 Jun 2005 21:50:40 -0300 (ADT) Received: (qmail 16953 invoked from network); 22 Jun 2005 00:50:44 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 22 Jun 2005 00:50:44 -0000 From: "Greg Sabino Mullane" To: pgsql-performance@postgresql.org Subject: Re: Configurator project launched X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <42B8A327.8060908@commandprompt.com> Date: Wed, 22 Jun 2005 00:50:44 -0000 X-Mailer: JoyMail 1.48 Message-ID: <17c492d2af42972995595f73c426f2aa@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.122 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/420 X-Sequence-Number: 13057 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 >> Um, can't we just get that from pg_settings? >> >> Anyway, I'll be deriving settings from the .conf file, since most of the >> time the Configurator will be run on a new installation. > > Aren't most of the settings all kept in the SHOW variables anyway? As I said, it may not be applicable to this project, but thought I would offer. One gotcha the module makes transparent is that in older versions of PG, the variables are returned in a different way (via RAISE). My module will allow you to get the configuration for any connected database, for any configuration file, and the defaults for any known version, and do quick comparisons between them all. So you could use it to see what has changed between a particular server and its conf file, or the differences between two conf files, or the differences between two databases, or even show what has changed in the default conf file from 7.4.7 and 8.0.1. It will also allow you to rewrite the conf files in a standard way. I'm hoping to roll this into 1.44 or 1.45 or DBD::Pg. - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200506212046 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCuLWDvJuQZxSWSsgRAjUVAJ42oeveZBuutFo1G3Cs/3dRZWjKggCfS1Yf Tv5RWiG9s8Ucv/t/2HZ4/R8= =1eap -----END PGP SIGNATURE-----