From: aditya desai <admad123@gmail.com>
To: Steve Midgley <science@misuse.org>
Cc: Erik Brandsberg <erik@heimdalldata.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: Is there any way to invoke Java API from PostgreSQL
Date: Wed, 18 Aug 2021 15:48:57 +0530
Message-ID: <CAN0SRDFGeC74KuFJunEdNPPQV5sLpyzm63Ws7DhE8qXRO-2s=g@mail.gmail.com> (raw)
In-Reply-To: <CAJexoSKh4e8S54j1uq_K1bZ5fa6PDuC4BuF62YPRO=C57vG98Q@mail.gmail.com>
References: <CAN0SRDEWL_R9m_a+7V8PwDYr+vcyFRXDMRB=SZPXPO3uWi1rxg@mail.gmail.com>
<CAFcck8FzqCuL_CGy+Y9URAuikMyevW_18y9sWud5uYU669aMUA@mail.gmail.com>
<CAN0SRDHeFGESEvOLDJ+4dc2ck3rpp3qRUWu59Axxr4hSaAW1rQ@mail.gmail.com>
<CAJexoSKh4e8S54j1uq_K1bZ5fa6PDuC4BuF62YPRO=C57vG98Q@mail.gmail.com>
Thanks Steve!! All of the below are supported for DB Links.
Postgres VM - Oracle 12 c
Postgres VM - Azure Postgres
Azure Postgres - Azure Postgres
Oracle - Postgres VM
Oracle - Azure Postgres
Stuck with anything that is outgoing from Azure Postgres. Will check
Bastion Host or try pg_dump/restore.
Regards,
Aditya.
On Fri, Aug 13, 2021 at 10:10 PM Steve Midgley <science@misuse.org> wrote:
>
>
> On Thu, Aug 12, 2021 at 9:43 PM aditya desai <admad123@gmail.com> wrote:
>
>> Hi Erik,
>> Sincere apologies. Maybe I wasn't clear. We need to transfer data
>> between Azure PostgreSQL to On Prem Open Source PostgreSQL and Azure
>> PostgreSQL to on Prem Oracle. Azure PostgreSQL is not allowing outgoing
>> traffic through DB Links outside the same region. That's where we are
>> looking for API-like solutions.
>>
>> Regards,
>> Aditya.
>>
>> On Fri, Aug 13, 2021 at 10:02 AM Erik Brandsberg <erik@heimdalldata.com>
>> wrote:
>>
>>> Honestly, what you are saying is that you aren't allowed to use a
>>> firecracker due to fire concerns, but is there a way to use dynamite
>>> instead. If fdw isn't allowed, then callouts to other language
>>> environments shouldn't be allowed either.
>>>
>>> On Fri, Aug 13, 2021 at 12:28 AM aditya desai <admad123@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>> Is there any way to invoke Java API from PostgreSQL? We need to
>>>> transfer data between PostgreSQL and Oracle and oracle_fdw is not allowed
>>>> due to security concerns in the environment. Also one of PostgresQL in
>>>> Azure PostgreSQL and others are open source on prem.
>>>>
>>>>
>>>>
> Why not use PG replicate to a server that you do control (that might be
> Erik's "bastion" suggestion), or pg_dump/restore to a similar server, and
> then execute the business logic and ETL over to Oracle from there?
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: admad123@gmail.com, science@misuse.org, erik@heimdalldata.com, pgsql-sql@lists.postgresql.org
Subject: Re: Is there any way to invoke Java API from PostgreSQL
In-Reply-To: <CAN0SRDFGeC74KuFJunEdNPPQV5sLpyzm63Ws7DhE8qXRO-2s=g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox