Re: WAL to RAW devices ?
От | Alex Vinogradovs |
---|---|
Тема | Re: WAL to RAW devices ? |
Дата | |
Msg-id | 1188609002.6082.72.camel@localhost обсуждение исходный текст |
Ответ на | Re: WAL to RAW devices ? (Alvaro Herrera <alvherre@commandprompt.com>) |
Список | pgsql-general |
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. >
В списке pgsql-general по дате отправления: