I'm willing to do some writing if someone will explain things to me.
I've pretty much disected all the sql used by Rserv.pm to see what it
does so I've got a decent head start.
The two questions that are holding me up at this point are:
1. which column do you specify for setting up the replication on a table?
So far I've been using the primary key but I'm not sure what to do
in the case where there's a composite primary key.
2. how do I figure out what triggers are currently bound to a given table?
I'm having a problem dropping all the rserv stuff and recreating it
without starting with a fresh database. I'm working on scripts to be able
to swap the master and slave relationship.
I currently drop each table and drop each function but when they are
recreated I get errors like this on inserts
DBD::Pg::db do failed: ERROR: fmgr_info: function 68437: cache lookup
failed
ERROR: fmgr_info: function 68437: cache lookup failed
which makes me think that the trigger is calling a function that doesn't
exist.
Thanks,
Alex.
On Fri, 16 Feb 2001, Bruce Momjian wrote:
> > Hi is there any documentation for rserv other than the readme?
> >
> > I've got it working and I'm generally understanding what's going
> > on by reading the code and observing the changes to the
> > various _rserv_ tables but I would feel much more comfortable if
> > I could read or someone could explain exactly what is supposed to get
> > logged by the trigger and exactly how the Replicate script is supposed to
> > copy the data using the _rserv_log_ to the secondary server.
>
> FYI, this is a 7.1 beta item. We certainly need something more
> substantial than the README, but no one has offered to write it.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>