From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Aidan Van Dyk <aidan(at)highrise(dot)ca>, Josh Berkus <josh(at)agliodbs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, pgsql-hackers(at)postgresql(dot)org, Gregory Stark <stark(at)enterprisedb(dot)com>, Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
Subject: | Re: Permanent settings |
Date: | 2008-02-21 09:18:38 |
Message-ID: | 20080221091838.GC8138@svr2.hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Feb 20, 2008 at 06:38:09PM -0500, Bruce Momjian wrote:
> Aidan Van Dyk wrote:
> > * Josh Berkus <josh(at)agliodbs(dot)com> [080220 18:00]:
> > > All,
> > >
> > > I think we're failing to discuss the primary use-case for this, which
> > > is one reason why the solutions aren't obvious.
> >
> > > However, imagine you're adminning 250 PostgreSQL servers backing a
> > > social networking application. You decide the application needs a
> > > higher default sort_mem for all new connections, on all 250 servers.
> > > How, exactly, do you deploy that?
> > >
> > > Worse, imagine you're an ISP and you have 250 *differently configured*
> > > PostgreSQL servers on vhosts, and you need to roll out a change in
> > > logging destination to all machines while leaving other settings
> > > untouched.
> >
> > But, from my experience, those are "pretty much" solved, with things
> > like rsync, SCM (pick your favourite) and tools like "clusterssh,
> > multixterm", rancid, wish, expect, etc.
>
> Agreed. Put postgresql.conf on an NFS server and restart the servers.
You've never actually administered machines in this scenario in production,
have you?
NFS mounting things thruogh firewalls will have a *really* hard time
getting past any firewall config person worthy of his name, for example.
And there are countless of other scenarios where it can't be done.
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2008-02-21 09:20:38 | Re: Permanent settings |
Previous Message | Gregory Stark | 2008-02-21 09:11:38 | Re: VARATT_EXTERNAL_GET_POINTER is not quite there yet |