Re: Rserv question or docs?

From: adb <adb(at)Beast(dot)COM>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Rserv question or docs?
Date: 2001-02-17 02:42:08
Message-ID: Pine.GSO.4.10.10102161835210.2561-100000@hairdini.beast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2001-02-17 02:44:14 Re: PostgreSQL Benchmark
Previous Message Tatsuo Ishii 2001-02-17 02:29:14 Re: Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?