Hi All,

I'm kind of confused as to how log shipping works.  I've set up a  
cluster with one provider and two subscribers, with one of the  
subscribers having the -a flag on.  *.sql files are being generated  
on this machine, but I have no clue as to what to do with these files.

My end goal is to ship logs to a remote location where I've got a  
second cluster set up (1 provider and 2 subscribers).  In the event  
of a disaster, I'd like to be able to just tip-over to this remote  
location and continue as if nothing happened.

In the past, I've attempted FAILOVER, but this proved buggy, and I'd  
like to try out log shipping as an alternative.

The slony1_dump.sh script doesn't seem to do anything but generate  
a .sql file that is supposed to read data from stdin.  But how am I  
supposed to use this?  What's going to pipe stuff into stdin?

Could someone point me in the right direction?

Thanks!
--Richard
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general

Reply via email to