[EMAIL PROTECTED] wrote: > > > > How hard would it be to extend PITR for master-slave (hot backup) > > repliaction, which should then amount to continuously shipping logs to > > slave and doing nonstop PITR there :) > > I have not looked at the PITR patch yet, but it might be possible > to use the same PITR format to queue/log writesetswith postgres-r, > so we can have multi-master replication and PITR from the same > mechanism.
Yes, we do need a method to send write sets to the various nodes, and PITR may be a help in getting those write sets. However, it should be clear that we really aren't archiving-replaying them like you would think for PITR. We are only grabbing stuff from the PITR to send to other nodes. We may also be able to use PITR to bring nodes back up to date if they have fallen out of communication. -- 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
