oracle_fwd - is it safe or not?

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

oracle_fwd - is it safe or not?

piotrwlodarczyk89
Hi everyone,

I have some question considering about oracle_fdw and safety of use it in production environment.

Problem we would like to resolve using this extension is to move data from five Oracle tables to Postgres database. To avoid situation that we have to trasfer data using sftp/ssh or another file based approach we decided to install oracle_fdw.

Our administrator have some doubt about this extension. He asked us, are we sure that this extension safe enough and didn't make any kernel panic sytuation beacuse as all another extension, this one can operate on system kernel level. 

Therefore if it's possible can You tell me more about safety this extension and release procedure and community of this module?

--

Best Regards
Piotr Włodarczyk
Reply | Threaded
Open this post in threaded view
|

Re: oracle_fwd - is it safe or not?

Bruce Momjian
On Thu, Jan 31, 2019 at 05:37:00PM +0100, Piotr Włodarczyk wrote:

> Hi everyone,
>
> I have some question considering about oracle_fdw and safety of use it in
> production environment.
>
> Problem we would like to resolve using this extension is to move data from five
> Oracle tables to Postgres database. To avoid situation that we have to trasfer
> data using sftp/ssh or another file based approach we decided to install
> oracle_fdw.
>
> Our administrator have some doubt about this extension. He asked us, are we
> sure that this extension safe enough and didn't make any kernel panic sytuation
> beacuse as all another extension, this one can operate on system kernel level. 
>
> Therefore if it's possible can You tell me more about safety this extension and
> release procedure and community of this module?

Uh, oracle_fwd uses a kernel module?  Are you sure?  That is surprising.

--
  Bruce Momjian  <[hidden email]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

Reply | Threaded
Open this post in threaded view
|

Re: oracle_fwd - is it safe or not?

legrand legrand
In reply to this post by piotrwlodarczyk89
Hi,

We have use it to "archive" 2 Oracle databases (8i and 9i)
to pg 9.5 on windows (for a target of more than 250GB).

We also use it to monitor our Oracle 11g databases,
storing some performances / capacity planning data
(like ASH, AWR, ...) in Postgres.

In all cases, developer support was premium.

Regards
PAscal




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

lup
Reply | Threaded
Open this post in threaded view
|

Re: oracle_fwd - is it safe or not?

lup

On 1/31/19 12:48 PM, legrand legrand wrote:

> Hi,
>
> We have use it to "archive" 2 Oracle databases (8i and 9i)
> to pg 9.5 on windows (for a target of more than 250GB).
>
> We also use it to monitor our Oracle 11g databases,
> storing some performances / capacity planning data
> (like ASH, AWR, ...) in Postgres.
>
> In all cases, developer support was premium.
>
> Regards
> PAscal
>
Can you please expand on "support was premium".  I'm not sure if that
was the level of support purchased, or perhaps an indication that
support was heavily used. Or have I missed it entirely?



Reply | Threaded
Open this post in threaded view
|

Re: oracle_fwd - is it safe or not?

legrand legrand
lup wrote
> On 1/31/19 12:48 PM, legrand legrand wrote:
>>
>> In all cases, developer support was premium.
>>
> Can you please expand on "support was premium".  I'm not sure if that
> was the level of support purchased, or perhaps an indication that
> support was heavily used. Or have I missed it entirely?

Sorry for not being clear,
we had many questions (and one bug)
all answers (and one fix)
where always fast and high level quality

Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Reply | Threaded
Open this post in threaded view
|

Re: oracle_fwd - is it safe or not?

Peter Eisentraut-6
In reply to this post by Bruce Momjian
On 31/01/2019 18:53, Bruce Momjian wrote:
> On Thu, Jan 31, 2019 at 05:37:00PM +0100, Piotr Włodarczyk wrote:
>> Our administrator have some doubt about this extension. He asked us, are we
>> sure that this extension safe enough and didn't make any kernel panic sytuation
>> beacuse as all another extension, this one can operate on system kernel level. 
>>
>> Therefore if it's possible can You tell me more about safety this extension and
>> release procedure and community of this module?
>
> Uh, oracle_fwd uses a kernel module?  Are you sure?  That is surprising.

Perhaps he meant that the extension runs in the PostgreSQL "kernel" and
could crash PostgreSQL, which is true of any extension.  But oracle_fdw
seems reasonably popular, so I would expect a base level of quality.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services