Patch applied. Thanks. ---------------------------------------------------------------------------
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 <[EMAIL PROTECTED]> [ 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
