Re: Permanent settings - Mailing list pgsql-hackers

From D'Arcy J.M. Cain
Subject Re: Permanent settings
Date
Msg-id 20080221101914.b5b8cb3d.darcy@druid.net
Whole thread Raw
In response to Re: Permanent settings  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On Thu, 21 Feb 2008 10:30:00 +0100
Magnus Hagander <magnus@hagander.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@druid.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.


pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: Permanent settings
Next
From: Tom Lane
Date:
Subject: Re: insufficient data left in message