Thread: RServ replication
I asked a while back, is anyone managing this project? It has scripts that just plain don't work.
>>>>> "mlw" == mlw <markw@mohawksoft.com> writes: mlw> I asked a while back, is anyone managing this project? It has mlw> scripts that just plain don't work. It works. Not like a charm, but it works. Also, it's a nightmare to setup. -- Turbo __ _ Debian GNU Unix _IS_ user friendly - it's just ^^^^^ / /(_)_ __ _ ___ __ selective aboutwho its friends are / / | | '_ \| | | \ \/ / Debian Certified Linux Developer _ /// / /__| | | | | |_||> < Turbo Fredriksson turbo@bayour.com \\\/ \____/_|_| |_|\__,_/_/\_\ Gothenburg/Sweden [Hello to all my fans in domestic surveillance] Uzi assassination Noriega Iran Cocaine NORAD Albanian ammonium KGB nitrate security South Africa FBI congress [See http://www.aclu.org/echelonwatch/index.html for more about this]
Hi all, Does anyone want to write a setup guide for this (RServ), to go into the "Installation Guides" section on techdocs.postgresql.org? :-) Regards and best wishes, Justin Clift Turbo Fredriksson wrote: > > >>>>> "mlw" == mlw <markw@mohawksoft.com> writes: > > mlw> I asked a while back, is anyone managing this project? It has > mlw> scripts that just plain don't work. > > It works. Not like a charm, but it works. Also, it's a nightmare to setup. > > -- > Turbo __ _ Debian GNU Unix _IS_ user friendly - it's just > ^^^^^ / /(_)_ __ _ ___ __ selective about who its friends are > / / | | '_ \| | | \ \/ / Debian Certified Linux Developer > _ /// / /__| | | | | |_| |> < Turbo Fredriksson turbo@bayour.com > \\\/ \____/_|_| |_|\__,_/_/\_\ Gothenburg/Sweden > > [Hello to all my fans in domestic surveillance] Uzi assassination > Noriega Iran Cocaine NORAD Albanian ammonium KGB nitrate security > South Africa FBI congress > [See http://www.aclu.org/echelonwatch/index.html for more about this] > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi
Turbo Fredriksson wrote: > > Quoting mlw <markw@mohawksoft.com>: > > > Turbo Fredriksson wrote: > > > > > > >>>>> "mlw" == mlw <markw@mohawksoft.com> writes: > > > > > > mlw> I asked a while back, is anyone managing this project? It has > > > mlw> scripts that just plain don't work. > > > > > > It works. Not like a charm, but it works. Also, it's a nightmare to setup. > > > > The ApplySnapshot script doesn't work at all. It is a mess. > > It works, it's just _VERY_ (!!!) picky about the system is correctly setup... > > I'll send you my 'rServ setup script' (kind'a), and you can see how I do it... > For instance, (in ApplySnapshot.in) the line: my $conn = Pg::connectdb(sinfo); Should be: my $conn = Pg::connectdb($sinfo); There are a lot of these errors. The snapshot file parameter is not used in all the scripts, the server string is always zero, and so on. It really is a mess. The trigger function and the internal stuff works well enough. I have actually got the "Replacate" script working but I need to replicatate to multiple servers. I was contemplating using "PrepareSnapshot" followed by multiple "ApllySnapshot" calls. I am spending a few hours rewriting "RServ.pm" in C++ to make a daemon which will automatically replicate out to multiple servers. (I can't stand perl)