Message-ID: <1507802672.3007.5.camel@cybertec.at>
Subject: Re: synchronization between PostgreSQL and Oracle
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: ROS Didier <didier.ros@edf.fr>, "pgsql-performance@postgresql.org"
 <pgsql-performance@postgresql.org>,
 "pgsql-performance-owner@postgresql.org"
 <pgsql-performance-owner@postgresql.org>
Date: Thu, 12 Oct 2017 12:04:32 +0200
In-Reply-To: <28c9e5ed0a81404190611f71faf74903@PCYINTPEXMU001.NEOPROD.EDF.FR>
References: <28c9e5ed0a81404190611f71faf74903@PCYINTPEXMU001.NEOPROD.EDF.FR>
Organization: Cybertec
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

ROS Didier wrote:
>                I would like your advice  and recommendation about the following infrastructure problem :
> What is the best way to optimize synchronization between an instance PostgreSQL on Windows 7 workstation and an Oracle 11gR2 database on linux RHEL  ?
> Here are more detailed explanations
> In our company we have people who collect data in a 9.6 postgresql instance on their workstation that is disconnected from the internet.
> In the evening, they connect to the Internet and synchronize the collected data to a remote 11gr2 Oracle database.
> What is the best performant way to do this ( Oracle_FDW ?, flat files ?, …)

If the synchronization is triggered from the workstation with
PostgreSQL on it, you can either use oracle_fdw or pg_dump/sql*loader
to transfer the data.

Using oracle_fdw is probably simpler, but it is not very performant
for bulk update operations.

If performance is the main objective, use export/import.

Yours,
Laurenz Albe


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance