postgresql amazon-web-services oracle-golden-gate

Golden Gate Replication - Postgres Instances

Can golden gate be used for bidirectional replication of 2 postgres (RDS or Aurora) db instances in AWS?

Solution

No it, can't. PostgreSQL can be only the target of Oracle GoldenGate replication. It can not be the source database.

You can replicate from an another vendor (like Oracle, MS SQL, Sybase, DB2) to a PostgreSQL database.

To select a specific column from a table using php postgres
PGError: ERROR: column “recipes.id” must appear in the GROUP BY clause or be used in an aggregate function
Use functions in unique constraint on multiple columns
psql: FATAL: Ident authentication failed for user "postgres"
Update record of a cursor where the table name is a parameter
How do I (or can I) SELECT DISTINCT on multiple columns?
How list all tables with data changes in the last 24 hours?
Unable to delete duplicate rows with PostgreSQL
Delete duplicate rows from small table
How to delete duplicate rows without unique identifier
In-order sequence generation
SQLAlchemy SELECT WITH clause/statement (pgsql)
Accidentally restored a another database to the 'postgres' database how to correct
MERGE RETURNING into temp table without a CTE
How do I delete a fixed number of rows with sorting in PostgreSQL?
Can't subtract offset-naive and offset-aware datetimes
How can I get Postgres use my functional index
What is the correct way to implement a context manager in psycopg2?
Can Postgres silently ignore column constraint conflicts?
How to LIMIT the number of parent values, but return all children for each?
Get the first date of an ISO 8601 year and week
how can i get the last row with a given foreign key in yii2 with relations?
Nifi : How to move CSV content and its meta data to single table in Postgresdatabase using NiFi
SQLAlchemy hangs when sending ALTER TABLE
log4net:ERROR ConfigureFromXml called with null 'element' parameter for Postgres SQL
Postgres - SQL Recursivity to get the highest parent
RDS while connection error: no pg_hba.conf entry for host
Best way to select random rows PostgreSQL
How to list indexes created for table in postgres
How do you change a user in PostgreSQL?