Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjuin-0001sl-B7 for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 23:35:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjuhl-0006OV-Ol for pgsql-admin@arkaria.postgresql.org; Wed, 16 Jan 2019 23:34:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjuhl-0006OO-8k for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 23:34:41 +0000 Received: from sonic308-4.consmr.mail.bf2.yahoo.com ([74.6.130.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjuhW-0005J4-L6 for pgsql-admin@lists.postgresql.org; Wed, 16 Jan 2019 23:34:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1547681665; bh=IC4i8MisbnU4e4CMMj5ERYv+RpA/rdXxGlR7NZESbWs=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=DhgIN0XIWcHOdLFANkI1286EN8nN485mHvyraqd15o1FaINf+c72ITVNA6+32wMs2U86Aio+zh1NrCbzXynB8ltGSoo7HkIK4RaEHXtDtQpQtq6Eh+wDhW24aRegvhgeP4F25WwVQoR+sJAWdr64QjgQUBB/JitFb2IQABw5MtQul8eCTl9laCN03Dn7U3id/K/zlB3CWxiHpaaRYtia1oFXZ++oguA5yMZwVRbudqAR24Ao5OTmljKeL3XvVC/IzqUV/gaUgezvxbMz+VO4C+WKIjLONkkBAIvv2z0QDGbsUrR/kSMlWWR1ZnQsiKiyzluUn+vWjMyouMPJ0qbFxQ== X-YMail-OSG: zp_zuUgVM1mCFEVq.ncOc0WQTX40bGN0_6bEH8xX2LVfr8Vqj4Hh6lyIP_wcRd. a2gzFftzuQQm7ihZFAoyUGjWd.7611lNS5ytATUaa0ShlyQ07J0RQ3Clwgam7PVC6Hvn8vCKcoiH mc3NnibOcd6KpYEDQTTHrCj.E.yby4LQgTQiRjyvfc8tST6yY6Wn2ZvszFSTufciDO42JfbXcFgH wRXt7oiQXyAn4ystkyPIBDn7LfTcAdQlyPkTPp80SmUJhZDpEpMeOMCHgfm0DdmVwmlFcB_riYpI 2ZE1EQBA6NjiRyPpLfdP8t0IPBCRoSh3PjAgHHX_nNZCo5Otl1dCsx3V2PbIuxYxmgrd9d4wzUbf oa6E7s2D7lBseaRM2hED9z9v12v1SCKoR2OR6T.J3_1tc6amNqvZZ1WPmOcAfd.eX1Sx1FZ4D2tb FCKLW90fMhTkaTVdvMopJ9.HHYKtj.SuIaTN72saNi..aYUsQ67uLOCw65oGxAyLTc0C7ul6RWle SfJWHsApb8esP5Myasn83W96lq891MU.ZIImnRAcfpDqdZk4zAebqbhrG1b6UMKPfkBfchN3XnTn dl44dd9gF9Suwqv2a09PbmDI7.uC65OkkxMW8XBR9juEJNf_RVPBkqeulauB.8eivbnIhZpPTdT_ gQnFl9nT2WQDUsCEXq86.sJeJVt6gDYwDwwHujpbHoMeD0vOimnb85iwKOsn8PzEwiMfNywNS_g9 ekMXYTFcCklofJRp7E.8P0LoaMabgX5BlwLMDH4ObjjKPFH3_VRiZgx5qiM96vMZpeHxIhmETK8_ iS.g9awu.iDnr28AyhJhmebHyzOt8Uo5naz8OVXY0sg79E4XOuMlW2ex0SKka9_aNY9whm5JT56t Bq0mkgphFI8B_yIaOhogewQ3mTAkNZZuzCbV0u0cHlzynoZbxShsNcSYkZHmvSF0XufgJXg1eP64 yK7jZy4JCsJUSP9uCQIePuVjbT1QjDpAEwd16jvFXfXQvuFxlUKikF.AdWRsrH9iwDitB5yiHZip mutULGHDxJ7agi2sDvTO_vjg2ZPpMo1aaYG4CIs0QkrnDlrlC6WMHyfc47GqwWAeM_vdD5Z87wrU - Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.bf2.yahoo.com with HTTP; Wed, 16 Jan 2019 23:34:25 +0000 Date: Wed, 16 Jan 2019 23:34:23 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "David G. Johnston" Cc: "gilberto.castillo@etecsa.cu" , Shreeyansh Dba , Pgsql-admin Message-ID: <324790507.871335.1547681663176@mail.yahoo.com> In-Reply-To: References: <1382151693.17038706.1547223778133.ref@mail.yahoo.com> <1382151693.17038706.1547223778133@mail.yahoo.com> <560782983.17074510.1547224489903@mail.yahoo.com> <732616782.754403.1547669100729@mail.yahoo.com> <8b2bd545ff5c18410548e6e2fcb99a4e@etecsa.cu> <1492323826.781728.1547669875527@mail.yahoo.com> <446111583.758900.1547670918954@mail.yahoo.com> Subject: Re: [MASSMAIL]Re: Copying Data from Oracle to PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_871334_1716145484.1547681663174" X-Mailer: WebService/1.1.12857 YahooMailNeo Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 7099 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_871334_1716145484.1547681663174 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable so you said I need to install ora2pg on both servers, oracle=C2=A0db=C2=A0a= nd postgres db? thank you.=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir 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 t= o 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=20 On Wednesday, January 16, 2019 3:55 PM, David G. Johnston wrote: =20 On Wed, Jan 16, 2019 at 1:35 PM Pepe TD Vo 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.=C2=A0 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.=C2=A0 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.=C2=A0 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).=C2=A0 Though even that requirement seems like it can be relaxed if necessary.=C2=A0 It likely should be neither server. David J. =20 ------=_Part_871334_1716145484.1547681663174 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
= so you said I need to install ora2pg on both servers, oracle&n= bsp;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, lo= ve 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 generousl= y **Care deeply **Speak kindly.
*** Genuinely rich *** Faith= ful 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 PostgreS= QL
server to connect to the Oracle database directly as a= client.  It can
move data but doesn't really deal w= ith schema...it likely is something
you can forget and fo= cus on migrating data and schema simultaneously
with a pr= oduct 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 O= racle
client application and the standard PostgreSQL clie= nt application
(psql) to perform its work.  Basicall= y (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.  Lo= cal can be
any machine than can talk to the Oracle server= (and has the Oracle
client) and can talk to the PostgreS= QL server (and has the psql
client).  Though even th= at requirement seems like it can be relaxed if
necessary.=   It likely should be neither server.

David J.




------=_Part_871334_1716145484.1547681663174--