Yeah, that's the trick... I need high availability with high performance and nearly real-time synchronization ;-) Also, I've got FreeBSD here... ZFS will be out with 7.0 release, plus UFS2 has snapshotting capability too. But the whole method isn't good enough anyway.
> Oh, I see. > > What I've seen described is to put a PITR slave on a filesystem with > snapshotting ability, like ZFS on Solaris. > > You can then have two copies of the PITR logs. One gets a postmaster > running in "warm standby" mode, i.e. recovering logs in a loop. The > other one, in a sort of jail (I don't know the Solaris terminology for > this) stops the recovery and enters normal mode. You can query it all > you like at that point. > > Periodically you stop the server in normal mode, resync the snapshot > (which basically resets the "modified" block list in the filesystem), > take a new snapshot, create the jail and stop the recovery mode again. > So you have a fresher postmaster for queries. > > It's not as good as having a true hot standby, for sure. But it seems > it's good enough while we wait. > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
