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
>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
