Re: WAL to RAW devices ?

[Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com>]

Oh well, I guess I will just use some trigger to invoke a C
function and store the statements in a raw device with some
proprietary format, while the actual inserts don't take place
at all.

In case anyone has more ideas, please let me know.


On Fri, 2007-08-31 at 17:45 -0700, Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Alex Vinogradovs wrote:
> > Hi guys,
> > 
> > 
> > I've got a bunch of PosgreSQL servers connected to external storage,
> >  where a single server needs to be serving as WO database dealing with
> > INSERTs only, and bunch of other guys need to obtain a copy of that
> > data for RO serving, without taking resources on WO server.
> 
> You can't do that with PostgreSQL without replication. Unless you are
> willing to have outages with your RO servers to apply the logs.
> 
> Further you are considering the wrong logs. It is not the WAL logs, but
> the archive logs that you need.
> 
> Sincerely,
> 
> Joshua D. Drake
>