From: Pepe TD Vo <pepevo@yahoo.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: gilberto.castillo@etecsa.cu <gilberto.castillo@etecsa.cu>
Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
Date: Wed, 16 Jan 2019 23:34:23 +0000 (UTC)
Message-ID: <324790507.871335.1547681663176@mail.yahoo.com> (raw)
In-Reply-To: <CAKFQuwbt7jr9zuDE0jt6VGEFA=ytkTA8Qv3mTObT65nxEUo+pg@mail.gmail.com>
References: <1382151693.17038706.1547223778133.ref@mail.yahoo.com>
<1382151693.17038706.1547223778133@mail.yahoo.com>
<CAGDYbUOd=RJRPe7NyVpEjxOvEpsnpUiT0Qtu3vBYEO7uk_XvgQ@mail.gmail.com>
<560782983.17074510.1547224489903@mail.yahoo.com>
<CAGDYbUNt-ufg93qgAy-_x862c4W00T-YqZHkZXS+kw6118fEfQ@mail.gmail.com>
<732616782.754403.1547669100729@mail.yahoo.com>
<8b2bd545ff5c18410548e6e2fcb99a4e@etecsa.cu>
<1492323826.781728.1547669875527@mail.yahoo.com>
<d593e8b33d2aeabdb868093d6f2ff08c@etecsa.cu>
<446111583.758900.1547670918954@mail.yahoo.com>
<CAKFQuwbt7jr9zuDE0jt6VGEFA=ytkTA8Qv3mTObT65nxEUo+pg@mail.gmail.com>
so you said I need to install ora2pg on both servers, oracle db and postgres db?
thank you. Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success
On Wednesday, January 16, 2019 3:55 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Jan 16, 2019 at 1:35 PM Pepe TD Vo <pepevo@yahoo.com> wrote:
> Need to download oracl-fdw?
oracle-fdw is PostgreSQL Server software that allows the PostgreSQL
server to connect to the Oracle database directly as a client. It can
move data but doesn't really deal with schema...it likely is something
you can forget and focus on migrating data and schema simultaneously
with a product designed to do just that (which ora2pg seems to be).
> I am asking where should I install ora2pg?
ora2pg is a piece of client software the uses both the standard Oracle
client application and the standard PostgreSQL client application
(psql) to perform its work. Basically (I've never actually used it)
it downloads the relevant data, using a normal client connection, from
the Oracle server to local files; processes those local files so that
they are now compatible with PostgreSQL; then uses psql to load the
newly transformed files into the PostgreSQL database. Local can be
any machine than can talk to the Oracle server (and has the Oracle
client) and can talk to the PostgreSQL server (and has the psql
client). Though even that requirement seems like it can be relaxed if
necessary. It likely should be neither server.
David J.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, david.g.johnston@gmail.com, gilberto.castillo@etecsa.cu, shreeyansh2014@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL
In-Reply-To: <324790507.871335.1547681663176@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox