Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46374=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cmG8s-0001Mo-GU
	for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 08:43:18 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46374=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cmG8r-0008AS-Gq
	for pgsql-admin@arkaria.postgresql.org; Fri, 10 Mar 2017 08:43:17 +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 <mark.kirkwood@catalyst.net.nz>)
	id 1cmG8q-00089v-Gc
	for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 08:43:16 +0000
Received: from cat-porwal-prod-mail1.catalyst.net.nz ([202.78.240.226])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <mark.kirkwood@catalyst.net.nz>)
	id 1cmG8f-0000Sp-On
	for pgsql-admin@postgresql.org; Fri, 10 Mar 2017 08:43:12 +0000
Received: from localhost (localhost [127.0.0.1])
	by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTP id A5314809CF
	for <pgsql-admin@postgresql.org>; Fri, 10 Mar 2017 21:42:58 +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 nOKxvGexQUDJ for <pgsql-admin@postgresql.org>;
	Fri, 10 Mar 2017 21:42:57 +1300 (NZDT)
Received: from [192.168.1.64] (122-62-67-15.jetstream.xtra.co.nz
 [122.62.67.15])
	(Authenticated sender: mark.kirkwood@catalyst.net.nz)
	by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 7E26080991
	for <pgsql-admin@postgresql.org>; Fri, 10 Mar 2017 21:42:57 +1300 (NZDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=catalyst.net.nz;
	s=catalyst; t=1489135377;
	bh=bsN13TChLSBIme58Q9xdfV+GFmlerlRXCKuBvzyBfFs=;
	h=To:From:Subject:Date;
	b=cOlkrpQYuX3ph2C4MSVw+h/TJfcTYKOcRbGa8ymZictd7IgEfWV6WUqI2jaTBLi4O
	 X8uONUnzOZ97j2dp0lGhGXNy9gu/xj8A9Odqk9vMh3a8tmPlEpXZAcmxWzlVldpnMU
	 AMDwTNRIaiRX2m3ZZeAiCpU3a+pN40g1+wwttqIY=
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Subject: Oracle to Postgres conversion suggestions?
Message-ID: <25a7213d-23ce-dabb-c2e7-d3e3fa26e855@catalyst.net.nz>
Date: Fri, 10 Mar 2017 21:42:57 +1300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.7.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -4.3 (----)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi,

I've been asked to help with one of these. I'm a bit wary, as I'm 
thinking this is actually a really high risk endeavor. Any thoughts on 
toolkits that might make this easy?


details:

- db size approx 5TB

- blob and (Oracle) spatial datatypes involved

- conversion and heterogeneous replication solutions needed


Currently looking at Amazon schema conversion/data migration services 
but wondering if there are known good solutions out there!


Cheers


Mark



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin