Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1crAsW-0002Yc-9p for pgsql-admin@arkaria.postgresql.org; Thu, 23 Mar 2017 22:06:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1crAsV-00014U-Sh for pgsql-admin@arkaria.postgresql.org; Thu, 23 Mar 2017 22:06:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1crAqY-0003yO-WA for pgsql-admin@postgresql.org; Thu, 23 Mar 2017 22:04:43 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([2404:130:4080::4]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1crAqU-0001rp-Kj for pgsql-admin@postgresql.org; Thu, 23 Mar 2017 22:04:42 +0000 Received: from localhost (localhost [127.0.0.1]) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTP id 90DD180880 for ; Fri, 24 Mar 2017 11:04:30 +1300 (NZDT) X-Virus-Scanned: Debian amavisd-new at cat-porwal-prod-mail1.servers.catalyst.net.nz Received: from cat-porwal-prod-mail1.catalyst.net.nz ([127.0.0.1]) by localhost (cat-porwal-prod-mail1.servers.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id hfVk1zC7SQCw for ; Fri, 24 Mar 2017 11:04:29 +1300 (NZDT) Received: from [IPv6:2404:130:0:1000:83e:8260:60b1:7d8] (unknown [IPv6:2404:130:0:1000:83e:8260:60b1:7d8]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 89E0A809E3 for ; Fri, 24 Mar 2017 11:04:29 +1300 (NZDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=catalyst.net.nz; s=catalyst; t=1490306669; bh=z2RWHeSZyvoJY3B7Xm6gI1KER22ExNl67HTxsmqpAi8=; h=Subject:To:References:From:Date:In-Reply-To; b=Js/tuU7u5OGgb4J/vb2iB3aljIsK51+zNNsVI0tpmgRkU4Xep+JIVcipHKT4zP40Y bI3b4IBwAi+1ii8f/pPLeswXJStU9m07SdaciwM1ZB9sAzXWJt6COv0YBVgzYjqWL2 Le0aU/HqUUHz24fD2Qj3ncADLLQnxW5zevRQjSIg= Subject: Re: Replication Between heterogeneous Databases To: pgsql-admin@postgresql.org References: From: Mark Kirkwood Message-ID: Date: Fri, 24 Mar 2017 11:05:02 +1300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Amazon has DMS (Data Migration Services) which will do this. Obviously (from the name) it is targeted at migrating data, but it does have the ability to replicate ongoing changes (I'm looking at using this for a migration Oracle to Postgres). regards Mark On 24/03/17 00:09, Panneer Selvam wrote: > Dear All, > > We would like to know about the replication mechanism or product available > & supported for replicating data between Heterogeneous systems - most > preferably between Oracle -> PostgreSQL. > > Regards, > Panneerselvam D > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin