RServ replication
"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]
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)