We need to replicate an oracle table into a postgresql database, now we are doing that with etl jobs and programatically but the frequence of the updates are to high for this approach. I was thinking to change the strategy doing:
1) build a fdw connecting this external oracle table to the postgresql db target server
2) setup a postgresql native ( streaming or logical, whichever works ) replication pointing to this fdw oracle connection.
Is that possible?