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 <ajs at crankycanuck.ca> 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
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 



      __________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com