Re: RServ patch to support multiple slaves (sorta)

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