Thread: oracle_fwd - is it safe or not?
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
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