pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Jay Korrapati <jaykorrapati@outlook.com>
To: David <dbwagoner@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
Date: Wed, 19 Aug 2020 07:55:55 +0200
Message-ID: <2d21028c6859fa74da7b887de4dbfd2ff44abdd9.camel@cybertec.at> (raw)
In-Reply-To: <BYAPR06MB589447AB6270351267DFC67AC75C0@BYAPR06MB5894.namprd06.prod.outlook.com>
References: <BYAPR06MB589466C9935230D0B43FC96EC7450@BYAPR06MB5894.namprd06.prod.outlook.com>
	<CACvbmBJ5va7ege2o8nXbcAgTgKqEYoHosiSZC5yyPkF7hnoB=Q@mail.gmail.com>
	<BYAPR06MB589447AB6270351267DFC67AC75C0@BYAPR06MB5894.namprd06.prod.outlook.com>

Jay Korrapati wrote:
> I checked out this. But this does not get me real-time data from On prem Oracle to Posgres in Azure.
>  There is a time delay for data to migrate.

If you want to access live Oracle data in PostgreSQL, you need oracle_fdw.

But you won't be able to get that on a hosted database.

This is one of the many reasons why hosted databases, despite being beneficial
in many ways, are not a good solution for everything.

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






view thread (4+ messages)

Message-ID: <2d21028c6859fa74da7b887de4dbfd2ff44abdd9.camel@cybertec.at>
Permalink:  ../2d21028c6859fa74da7b887de4dbfd2ff44abdd9.camel@cybertec.at/
Also on:    postgresql.org/message-id/2d21028c6859fa74da7b887de4dbfd2ff44abdd9.camel@cybertec.at

 · 

reply
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-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, jaykorrapati@outlook.com, dbwagoner@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
  In-Reply-To: <2d21028c6859fa74da7b887de4dbfd2ff44abdd9.camel@cybertec.at>

* 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