PostgreSQL mgmt on Fedora: pg_cluster-like tools?

[Les Mikesell]

Devrim GÜNDÜZ wrote:
> On Fri, 2008-09-12 at 17:28 +1200, Martin Langhoff wrote:
>> OTOH, we know what apps talk to Pg, and we'll have tested them
>> thoroughly. The failures could come from data that breaks during
>> migration - so if an 8.3 to 8.4 migration fails to complete we keep
>> running on Pg 8.3, and write a log.
> 
> So to which directory do you want us to get backup? What if it is filled
> in the middle of dumping? We have some customers that has hundreds GB of
> data -- can you imagine how long will the dump take? During the dump, we
> have do shutdown (actually don't allow anyone else than localhost/Unix
> domain sockets) PostgreSQL in order to be able to migrate correctly. It
> will be really painful. PostgreSQL project has Slony-I to be used in
> such migrations (almost) without downtime.
> 
> So,  IMHO what Fedora should do is to be able to install many versions
> in parallel, and leave the rest of DBA work to the users.

I agree that the package manager should have the ability to install 
multiple versions of things - and not just in this case.  But, what/who 
should determine which executables/libraries go in the default path?

-- 
   Les Mikesell
    lesmikesell at gmail.com