Skip site navigation (1) Skip section navigation (2)

Re: replication using WAL archives

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Iain <iain(at)mst(dot)co(dot)jp>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: replication using WAL archives
Date: 2004-10-21 18:41:21
Message-ID: 1098384082.15573.14.camel@camel (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

Responses

pgsql-admin by date

Next:From: Uwe C. SchroederDate: 2004-10-21 19:05:09
Subject: psql enhancement idea
Previous:From: Robert TreatDate: 2004-10-21 18:38:55
Subject: Re: data not getting inserted into table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group