Re: Copying Data from Oracle to PostgreSQL - Mailing list pgsql-admin

From Pepe TD Vo
Subject Re: Copying Data from Oracle to PostgreSQL
Date
Msg-id 74388008.1250118.1547744094605@mail.yahoo.com
Whole thread Raw
In response to Re: Copying Data from Oracle to PostgreSQL  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
this is not production server.  We need to test out on development servers before playing with a real one.
 
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 Thursday, January 17, 2019 11:52 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:


On Thu, Jan 17, 2019 at 9:24 AM Pepe TD Vo <pepevo@yahoo.com> wrote:

> I don't have a 3rd server to install ora2pg to connect between two oracle and postgres db servers.  Contract is not funded to get extra server(s) and/or training.


Assuming the existing Oracle server is in production I would recommend
you not install stuff there which only leaves the new PostgreSQL
server as an option given your apparent limitations.

That's likely that last I will say on the topic - I agree with
Laurenz's sentiments; You don't seem to be in a position to personally
fulfill this contract that you've been assigned and you need to
consider how to deal with that fact.  You haven't even gotten to the
hard part yet and your hands are tied in ways they should not be
(i.e., the machine you are performing the work on, a newly created
virtual machine workstation ideally, should have internet access).

David J.



pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Copying Data from Oracle to PostgreSQL
Next
From: Gary Stainburn
Date:
Subject: upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8