Re: WAL to RAW devices ? - Mailing list pgsql-general

From Alex Vinogradovs
Subject Re: WAL to RAW devices ?
Date
Msg-id 1188609002.6082.72.camel@localhost
Whole thread Raw
In response to Re: WAL to RAW devices ?  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: WAL to RAW devices ?
Next
From: Tom Lane
Date:
Subject: Re: Out of Memory - 8.2.4