You could take your backup from the origin instead of the subscriber.

On January 11, 2008 12:59:25 pm Glyn Astill wrote:
> 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
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general



-- 
Tim Goodaire    416-673-4126    tgoodair at ca.afilias.info
Database Team Lead, Afilias Canada Corp.