I'm in the process of building a system that uses slony-I for replication, and I'm just starting to look at the best ways to do my backups.
So far until I saw this thread I'd assumed that I could do a pg_dump on a subscriber and keep that as my main backup. Or do a file system backup of the subscriber. In this case what would be the best way to restore the system from that backup in the case of a publisher failing? Any ideas on backup / restore techniques would be appreciated. --- Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Fri, Jan 11, 2008 at 11:05:23AM -0500, Christopher Browne wrote: > > > > Actually, it's now used in the regression test that tests out log > > shipping, so I think that the claim that it "doesn't seem to have > had > > a lot of testing" is becoming unfair. > > Excellent news! > > > Note that this all is to change in the next major Slony-I > release; > > with the changes in trigger support in PG 8.3, there is no longer > a > > need to fool with the system catalog, so pg_dump becomes usable > again. > > Right, I forgot to mention that. > > A > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > __________________________________________________________ Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
