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 > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 >
