From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-performance@postgresql.org
Subject: Re: Configurator project launched
Date: Wed, 22 Jun 2005 00:50:44 -0000
Message-ID: <17c492d2af42972995595f73c426f2aa@biglumber.com> (raw)
In-Reply-To: <42B8A327.8060908@commandprompt.com>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@turnstep.com
Subject: Re: Configurator project launched
In-Reply-To: <17c492d2af42972995595f73c426f2aa@biglumber.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox