On 8/26/2008 1:37 PM, Phoenix Kiula wrote:
> I am not interested in being a Slony expert or a fabulous DBA. I just
> want something that does the job of letting me upgrade a DB. (I am not
> looking for regular replication, but I was forwarded from the
> PG-GENERAL list to come here and ask how to use Slony to perform the
> anal experience that is the PG upgrade. I am not impressed so far!)

I am fully aware of your problem and am in the process of addressing it. 
It just won't happen in a week or two, that's for sure.

In my ignorant and naive manner I originally thought that providing 
nothing but this brutally horrible, noob-unfriendly "slonik" thing would 
cause someone to step up and build something useful. Didn't happen.

Next thought ... maybe it could be integrated into pgAdmin-III? Already 
a GUI tool, perfect! Well, that didn't get far either and in hindsight, 
it was a terrible thought to begin with because pgAdmin is the LAST 
thing you want on a production server. pgAdmin is despite its name a 
development tool that lets you create, alter and drop just about each 
and every database object with the click of a button ... kinda like 
having a full development environment and typing "make install". Neat, 
but not on a production server where dropping the wrong table is a 
disaster. So integrating basic replication administration into such a 
tool is a bad idea.

I am currently drafting requirements for a graphical configuration and 
status monitoring tool. The DBA's here at Afilias are over and over 
again drawing little "cluster diagrams" on a white board or just paper, 
in order to get an "overview" of the current configuration. And that, I 
think, some program can do much faster and more accurate.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin