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@nachbaur.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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073