Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Avinash Kumar <avinash(dot)vallarapu(at)gmail(dot)com>
Cc: Pepe TD Vo <pepevo(at)yahoo(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org, Thomas Kellerer <shammat(at)gmx(dot)net>
Subject: Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Date: 2020-04-24 14:50:30
Message-ID: aa858bf13f52e32448216fb1b383cebe6682f4f4.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2020-04-24 at 10:35 -0300, Avinash Kumar wrote:
> On Fri, Apr 24, 2020 at 10:31 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> > On Fri, 2020-04-24 at 13:28 +0000, Pepe TD Vo wrote:
> > > is a foreign-data wrapper open source?
> >
> > Yes, see the license.
> > The page is https://laurenz.github.io/oracle_fdw/
>
> Was it due to the tricky part of Oracle libraries linking and dependency on Oracle client that you did not plan to think of creating an RPM of it ?
> Not sure if it was discussed before, but what was the reason for Oracle_FDW not being available in PGDG repo ?

No, but rather that there is a plethora of Linux distributions in various versions
on various architectures, and I'd have to create an RPM for any of them
(not to speak of the distributions that use other package managers).

And on Linux it is really easy to build the binaries.

About the PGDB packages, that's not for me to answer.
Perhaps it is not deemed important enough, perhaps there are technical or
license problems.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jonah H. Harris 2020-04-24 16:57:18 Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL
Previous Message soumitra bhandary 2020-04-24 13:42:34 Re: Help needed for replication issue