In the last exciting episode, [EMAIL PROTECTED] (Jochem van Dieten) wrote: > Josh Berkus wrote: >> I personally don't think that a GUI tool should be the province of >> the Slony project. Seriously. I think that Slony should focus on >> a command-line api and catalogs, and allow the existing GUI >> projects to build a slony-supporting interface. > > Why a command line api? I believe it would make sense to be able to > configure and control all nodes of the entire system from psql > connected to any of the nodes. That would also facilitate the > existing GUI projects in adding a Slony-manager.
Interesting... That would mean that the 'server' part of the application would be 'monitoring' NOTIFY requests on each of the nodes, right? Hmm... Queue up some records in the slony1.node_requests table, to indicate what needs to be changed, then NOTIFY "slony1". The server then has to look at _all_ the nodes for slony1.node_requests entries. It would be _very_ easy to write command line apps to manage this; no need to add any extra RPC scheme (e.g. - Java RMI, CORBA, talking to sockets), and no need to open extra firewall ports in addition to the ports already needed in order for Slony to communicate with the various databases. Further bonus: the "GUI project" need only have a database connection to one of the databases to control things. No need for ANYTHING else. After fleshing it out a little, that's a pretty slick approach. -- If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me http://cbbrowne.com/info/multiplexor.html 0 7 * * * echo "...Linux is just a fad" | mail [EMAIL PROTECTED] \ -s "And remember..." ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
