Re: Permanent settings

Aidan Van Dyk wrote:
-- Start of PGP signed section.
> * 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.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +