Re: Permanent settings

On Thu, 21 Feb 2008 10:30:00 +0100
Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> Do you know of any cross-platform tool that is capable of dealing with the
> PostgreSQL configuration file in a context sensitive manner? Meaning that
> it doesn't just treat it as a big file, but you can actually do "for all
> these 32 servers, change work_mem to 2Mb"? If so, I'd like to know which
> one beause I could *raelly* use that one right now.

If it was me I would create a database that served variables and a
portable script - Python for me but Perl would probably work too - that
read variables from the database and plugged them into a basic
template. That way you can make localized changes to specific servers
by changing the database or global changes by changing the template.

--
D'Arcy J.M. Cain <darcy(at)druid(dot)net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.