Re: replication using WAL archives

On Thu, 2004-10-21 at 02:44, Iain wrote:
> Hi,
>
> I thought I read something about this in relation to v8, but I can't
> find any reference to it now... is it (or will it be) possible to do
> master-slave style database replication by transmitting log files to the
> standby server and having it process them?
>

I'm not certain if this is 8.0, but some folks have created a working
version against the 8.0 code that will do something like this. Search
the pgsql-hacker mail list archives for more information on it.

> Also, just out of interest, if I wanted to mine my log files so as to be
> able to produce SQL would that be feasible? Presumably pg does something
> like this internally for rollforward recovery, so I guess it would be
> possible.
>

If you want real SQL, you'll need to turn on SQL logging in
postgresql.conf.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL