Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6959FB5DC11 for ; Fri, 12 Aug 2011 20:37:45 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 34746-07-2 for ; Fri, 12 Aug 2011 23:37:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id A58CCB5DC23 for ; Fri, 12 Aug 2011 20:37:37 -0300 (ADT) Received: by vws1 with SMTP id 1so2846694vws.19 for ; Fri, 12 Aug 2011 16:37:37 -0700 (PDT) Received: by 10.220.191.199 with SMTP id dn7mr399165vcb.60.1313192255870; Fri, 12 Aug 2011 16:37:35 -0700 (PDT) Received: from [10.1.1.8] (124-169-181-228.dyn.iinet.net.au [124.169.181.228]) by mx.google.com with ESMTPS id n5sm1536103vcw.8.2011.08.12.16.37.32 (version=SSLv3 cipher=OTHER); Fri, 12 Aug 2011 16:37:35 -0700 (PDT) Message-ID: <4E45B938.6000606@ringerc.id.au> Date: Sat, 13 Aug 2011 07:37:28 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20110624 Thunderbird/5.0 MIME-Version: 1.0 To: CS DBA CC: =?UTF-8?B?RGV2cmltIEfDnE5Ew5xa?= , PG Admin Subject: Re: replication from Oracle to PostgreSQL? References: <4E43EA0B.3080600@consistentstate.com> <1313074397.2506.710.camel@lenovo01-laptop03.gunduz.org> <4E43EDD4.1060700@consistentstate.com> <4E448B6C.8060700@ringerc.id.au> <4E453B46.8070108@consistentstate.com> In-Reply-To: <4E453B46.8070108@consistentstate.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.18 tagged_above=-10 required=5 tests=BAYES_00=-1.9, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201108/119 X-Sequence-Number: 38106 On 12/08/2011 10:40 PM, CS DBA wrote: >> There are lots of ETL tools available, and there's always the >> roll-your-own queue-based trigger replication system option. Of >> course, both options would probably cost more than buying EDB's >> already built and tested version... >> > interesting idea, any specific ETL tools you could recommend? The main open source ones I hear about are Talend (http://uk.talend.com/index.php) and Pentaho (http://www.pentaho.com/). These are the only two I hear of people on this list using, but that doesn't mean others don't see use too. Others found in a quick search include CloverETL (http://www.cloveretl.com/) and Aptar (http://apatar.com/). I'm sure there are tons more, but who knows what they're like. -- Craig Ringer