You can run the SharePlex installer for PostgreSQL on Linux in an Interactive or Unattended mode. For more information on the steps to run the installer, see Install SharePlex on Linux/Unix for open target databases.
Set up replication from PostgreSQL to PostgreSQL
Set up replication from PostgreSQL to Oracle
This chapter contains instructions for configuring SharePlex to replicate from PostgreSQL to a different type of target. This is known as heterogeneous replication.
These instructions highlight specific tasks that are pertinent to the flow of data between source and target. Refer to other topics in the SharePlex documentation as needed to complete the configuration, deploy any optional features that apply, and monitor and maintain the environment.
For additional information, see:
Note: These instructions apply to all implementations of PostgreSQL unless otherwise noted.
SharePlex can post replicated PostgreSQL data to a PostgreSQL target database through an Open Database Connectivity (ODBC) interface. SharePlex supports all implementations of the PostgreSQL open-source database.
These instructions contain setup instructions that are specific to this target. Install SharePlex on the source and target according to the appropriate directions in this manual before performing these setup steps.
For the versions, data types and operations that are supported when using SharePlex to replicate to this target, see the SharePlex Release Notes.
Set up SharePlex and the database on the PostgreSQL source and target system as follows.
On the source, create a SharePlex configuration file that specifies capture and routing information.
| Datasource:r.source_DB | ||
|
src_schema.table |
tgt_schema.table |
host@r.database_name |
where:
| * Important!
Target schema or table name defined in the database is case sensitive, be certain to:
Note: This is a basic one-source, one-target configuration using no additional SharePlex configuration features. See "Configure SharePlex to replicate data" in the SharePlex Administration Guide for important information about creating a configuration file and for additional setup instructions for more complex replication scenarios. |
The following configuration file replicates table HR.Emp from PostgreSQL instance dbname112 to target table region1.emp in database mydb on target system hostB. The source table is case-sensitive.
Datasource:r.dbname112
HR."Emp" region1.emp hostB@r.mydb
SharePlex can post replicated PostgreSQL data to an Oracle target database through an Open Database Connectivity (ODBC) interface. SharePlex supports all implementations of the PostgreSQL open-source database.
These instructions contain setup instructions that are specific to this target. Install SharePlex on the source and target according to the appropriate directions in this manual before performing these setup steps.
For the versions, data types and operations that are supported when using SharePlex to replicate to this target, see the SharePlex Release Notes.
Set up SharePlex and the database on the PostgreSQL source and an Oracle target system as follows.
On the source, create a SharePlex configuration file that specifies capture and routing information.
| Datasource:r.dbname | ||
|
src_schema.table |
tgt_owner.table |
host@o.database_name |
where:
| * Important!
Target schema or table name defined in the database is case sensitive, be certain to:
Note: This is a basic one-source, one-target configuration using no additional SharePlex configuration features. See "Configure SharePlex to replicate data" in the SharePlex Administration Guide for important information about creating a configuration file and for additional setup instructions for more complex replication scenarios. |
|
# data2k configuration file | ||
|
datasource:r.source_databasename | ||
| "demo"."data2k" | "DEMO"."DATA2K" | target_system@o.target_databasename |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
