oracle_fwd - is it safe or not?

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 <bruce@momjian.us> 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 +

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

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?

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

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