Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k8H4s-0004ni-Ne for pgsql-admin@arkaria.postgresql.org; Wed, 19 Aug 2020 05:56:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k8H4r-00077f-Ms for pgsql-admin@arkaria.postgresql.org; Wed, 19 Aug 2020 05:56:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k8H4r-00077Y-2S for pgsql-admin@lists.postgresql.org; Wed, 19 Aug 2020 05:56:01 +0000 Received: from mail-ed1-x536.google.com ([2a00:1450:4864:20::536]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1k8H4o-0001kj-4b for pgsql-admin@lists.postgresql.org; Wed, 19 Aug 2020 05:56:00 +0000 Received: by mail-ed1-x536.google.com with SMTP id i26so17111715edv.4 for ; Tue, 18 Aug 2020 22:55:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:cc:date:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=06O/iZbAbsyE0FNqfXNDIdeRzIavW7TbkSr5uvWBBrE=; b=dg6kr1oCLa/ishUxCG7KyOtBX9GlXWcLc+UbIY2aD9oRfi7G8rbf2LDN4oav0uOu6f nZNJwVDrQ0+YeHzfRkVEWqWa9alNylzyDrgZBlqqEFbknhpBGxkQerbVJvP/eAzXPxRD LTh2sFObc6B6dnNWSGn+ZGoR1c8qU3mThUpqiVM5spj74HOxWdAtcwqlPRO+7tJTga5e c6+Dq2p5VsWsCp13BrJn3c9E1nXWHZj+NKGvrGjOCyQ4+gWcU3/r/pUHyfPscLWUBMlT n1FdfpUFF1m0cj+SEPidGKWCC2aTwP99TAKh+9j7E5nuCvOi3SugVLpU6FhQ+g5JQd9j 35dg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=06O/iZbAbsyE0FNqfXNDIdeRzIavW7TbkSr5uvWBBrE=; b=hH0x2AjdZAAGBUQ2jZP60zPalNjxx52Sgx1u3mU+WToL6k557rJXoBj1yfhf3q93IU xwQNz5cx+PR6dH7059hlkgmd/wxp7IIh9wP2c8w1wMm1v5qkeHtA51i58zeWhsWkynyv ELzKuNpbRAklr4nONRRl3bTFJ2OXxJcdyOGkav2sJAf4AbxfLKgslfLx6/SNo80tIJfR e6BJsOtBgmlV2zj8QjpzMhSrQHTOulXUWiW2QYQe8ONuNUFlyCZqnI5hW5s0JoEOlOz+ 3SVDiVnRAJGVRF7RoNF0LzH5SApi4oU2OOd3GPEwHosiq51RvVUlwj1uIsmHYf8LvYu6 8yMA== X-Gm-Message-State: AOAM5309hEkLV+QSdwYPmToYG+3k14kZcbzdMIWE3xYEG0PxYcx5cgTB ghumD9nu/0ggAg1ygTKyaU4dHw== X-Google-Smtp-Source: ABdhPJyOqxZHqhVyiIku4Y933AMEJ1IS64AcUtpLnjXm1BWYRNX637ZAdAHko6Ob4ZVOYlhp/ByD3g== X-Received: by 2002:a50:d2c7:: with SMTP id q7mr22163085edg.61.1597816556656; Tue, 18 Aug 2020 22:55:56 -0700 (PDT) Received: from dynamic-epcx5vc3z4yzjp82i-pd01.res.v6.highway.a1.net (dynamic-epcx5vc3z4yzjp82i-pd01.res.v6.highway.a1.net. [2001:871:60:cd86:e07e:ef61:ebc5:741a]) by smtp.gmail.com with ESMTPSA id ha23sm2706260ejb.47.2020.08.18.22.55.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 18 Aug 2020 22:55:56 -0700 (PDT) Message-ID: <2d21028c6859fa74da7b887de4dbfd2ff44abdd9.camel@cybertec.at> Subject: Re: Data sync between Oracle Non Cloud and PostgresDb in Azure From: Laurenz Albe To: Jay Korrapati , David Cc: "pgsql-admin@lists.postgresql.org" Date: Wed, 19 Aug 2020 07:55:55 +0200 In-Reply-To: References: , Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-1.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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