Re: RServ patch to support multiple slaves (sorta)

From: Michael A Nachbaur <mike(at)nachbaur(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RServ patch to support multiple slaves (sorta)
Date: 2003-06-25 21:47:52
Message-ID: 200306251447.52509.mike@nachbaur.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thursday 19 June 2003 07:36 pm, Michael A Nachbaur wrote:
> Attached is a patch that provides *VERY* limited support for multiple slave
> servers. I haven't tested it very well, so use at your own risk (and I
> recommend against using it in production).
<snip>

Okay, I just did some more testing, and found out that my code actually
doesn't work. Consider the attached test case (if run with "-delete", it
will delete the master, slavea - slavec databases that it creates).

Anyway, it looks like it replicates the "A" table just fine, and the slaveb
and slavec databases replicate just fine, but the "SyncID" was incremented by
the SlaveA replication, and therefore "b" and "c" never get updated.

I don't know enough about how the RServ code works right now to fix this right
away. Any ideas? Or should I just figure it out for myself? (I know
everyone is busy getting ready for the feature freeze)

--
Michael A Nachbaur <mike(at)nachbaur(dot)com>

Attachment Content-Type Size
replicate-testcase.sh application/x-shellscript 2.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2003-06-25 22:11:11 pg_dump, schemas and 7.4/7.3
Previous Message Bruce Momjian 2003-06-25 21:40:47 Re: [GENERAL] capturing and storing query statement with