From hue@lavoisier.fr Mon Sep 26 15:53:46 2005 X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 623C2D9752 for ; Mon, 26 Sep 2005 12:53:46 -0300 (ADT) 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 23583-01 for ; Mon, 26 Sep 2005 15:53:43 +0000 (GMT) Received: from laplace.lavoisier.fr (laplace.lavoisier.fr [195.6.198.250]) by svr1.postgresql.org (Postfix) with ESMTP id 303E5D9760 for ; Mon, 26 Sep 2005 12:53:42 -0300 (ADT) Received: from (HUEROBERT) [195.6.198.193] by laplace.lavoisier.fr with esmtp (Exim 4.50 #2 (Debian)) id 1EJvJ2-00024x-Fu; Mon, 26 Sep 2005 17:54:16 +0200 From: "hue" To: Date: Mon, 26 Sep 2005 17:55:34 +0200 Message-ID: <001401c5c2b2$be48daa0$51c809c0@HUEROBERT> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0015_01C5C2C3.81D1AAA0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Importance: Normal X-SA-Exim-Connect-IP: 195.6.198.193 X-SA-Exim-Mail-From: hue@lavoisier.fr Subject: Synchronize Postgres with an other database X-SA-Exim-Version: 4.2 (built Mon, 12 Sep 2005 11:48:09 +0200) X-SA-Exim-Scanned: Yes (on laplace.lavoisier.fr) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.975 required=5 tests=[AWL=0.785, HTML_90_100=0.189, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/38 X-Sequence-Number: 5761 This is a multi-part message in MIME format. ------=_NextPart_000_0015_01C5C2C3.81D1AAA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I would like to read Postgres transaction log files to update an other database with an old structure base on files. The only solution I found is to read WAL files, but, the only way is with c program, I did not find a way to use WAL files with java program. Regards, Olivier. ------=_NextPart_000_0015_01C5C2C3.81D1AAA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I would like to read = Postgres transaction log files to update an other = database with an old structure base on files.

The only solution I = found is to read WAL files, but, the only way is with c program, I did not find a = way to use WAL files with java program.

Rega= rds, Olivier.

------=_NextPart_000_0015_01C5C2C3.81D1AAA0-- From david@stanaway.net Tue Sep 27 17:45:46 2005 X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7EA06D9947 for ; Tue, 27 Sep 2005 14:45:46 -0300 (ADT) 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 60441-09 for ; Tue, 27 Sep 2005 17:45:39 +0000 (GMT) Received: from mail.dialmex.net (67.107.77.98.ptr.us.xo.net [67.107.77.98]) by svr1.postgresql.org (Postfix) with ESMTP id 38052D777B for ; Tue, 27 Sep 2005 14:45:38 -0300 (ADT) Received: from david.dialmex.net (dmxnocws13.dialmex.net [67.107.77.78]) by mail.dialmex.net (Postfix) with ESMTP id A5D5BEE98E; Tue, 27 Sep 2005 12:45:38 -0500 (CDT) Subject: Re: Synchronize Postgres with an other database From: David Stanaway To: hue Cc: pgsql-interfaces@postgresql.org In-Reply-To: <001401c5c2b2$be48daa0$51c809c0@HUEROBERT> References: <001401c5c2b2$be48daa0$51c809c0@HUEROBERT> Content-Type: text/plain Date: Tue, 27 Sep 2005 12:45:38 -0500 Message-Id: <1127843138.23735.4.camel@dmxnocws13.dialmex.net> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/39 X-Sequence-Number: 5762 How many changes per minute are you planning for? Looking to the WAL files seems very low level, and I don't imagine it would be a good idea unless performance dictated it. Have you thought of setting up a trigger to log inserts/updates/deletes into a transaction table/tables that you can poll with a java application or whatever other language you want? On Mon, 2005-09-26 at 17:55 +0200, hue wrote: > Hi, > > > > I would like to read Postgres transaction log files to update an other > database with an old structure base on files. > > > > The only solution I found is to read WAL files, but, the only way is > with c program, I did not find a way to use WAL files with java > program. > > > > Regards, Olivier. > > > > > >