pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert Treat <xzilla@users.sourceforge.net>
To: Iain <iain@mst.co.jp>
Cc: pgsql-admin@postgresql.org
Subject: Re: replication using WAL archives
Date: 21 Oct 2004 14:41:21 -0400
Message-ID: <1098384082.15573.14.camel@camel> (raw)
In-Reply-To: <002801c4b739$68450870$7201a8c0@mst1x5r347kymb>
References: <002801c4b739$68450870$7201a8c0@mst1x5r347kymb>

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




view thread (9+ messages)  latest in thread

Message-ID: <1098384082.15573.14.camel@camel>
Permalink:  ../1098384082.15573.14.camel@camel/
Also on:    postgresql.org/message-id/1098384082.15573.14.camel@camel

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: xzilla@users.sourceforge.net, iain@mst.co.jp
  Subject: Re: replication using WAL archives
  In-Reply-To: <1098384082.15573.14.camel@camel>
  References: <002801c4b739$68450870$7201a8c0@mst1x5r347kymb> <1098384082.15573.14.camel@camel>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox