X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CF36832A923 for ; Thu, 21 Oct 2004 19:41:35 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20443-02 for ; Thu, 21 Oct 2004 18:41:32 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id AD38632A943 for ; Thu, 21 Oct 2004 19:41:33 +0100 (BST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i9LHeVBW023076; Thu, 21 Oct 2004 13:40:31 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i9LIfMm12632; Thu, 21 Oct 2004 14:41:22 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 4C2FDXM0; Thu, 21 Oct 2004 14:41:21 -0400 Subject: Re: replication using WAL archives From: Robert Treat To: Iain Cc: pgsql-admin@postgresql.org In-Reply-To: <002801c4b739$68450870$7201a8c0@mst1x5r347kymb> References: <002801c4b739$68450870$7201a8c0@mst1x5r347kymb> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 21 Oct 2004 14:41:21 -0400 Message-Id: <1098384082.15573.14.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/284 X-Sequence-Number: 15277 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