Re: RServ patch to support multiple slaves (sorta)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Michael A Nachbaur <mike(at)nachbaur(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RServ patch to support multiple slaves (sorta)
Date: 2003-06-24 03:01:32
Message-ID: 200306240301.h5O31W713134@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

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).
>
> Basically, I have a central database server that has 4 summary tables inside
> it replicated to a remote slave (these database tables are for my mail server
> authentication, so these are replicated to another server tuned for many
> connections, and so I don't have postgres connections opened straight to my
> back-end database server).
>
> Unfortunately, I also wanted to implement a replication database server for
> hot-backups. I realized, too late, that the replication process is pretty
> greedy and will try to replicate all tables marked as a "MasterAddTable".
>
> To make a long story, I made a patch to RServ.pm and Replicate that allows you
> to specify, on the command line, a list of tables that you want to
> replicate...it'll ignore all others.
>
> I haven't finished, since this has to be integrated with CleanLog for
> instance, but this should (and does) suffice for the moment.
>
> I have yet to test it with two slaves, but at least my mail server replication
> database now works (it was failing every time it tried to replicate, for a
> variety of reasons).
>
> Anyone have any suggestions on how to improve on this? (or, if someone more
> familiar with this code wants to take the ball and run with it, you're
> welcome to).
>
> --
> Michael A Nachbaur <mike(at)nachbaur(dot)com>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-06-24 03:04:16 PostgreSQL Core Welcomes New Member
Previous Message Bruce Momjian 2003-06-24 02:54:54 Re: PlPython