I've been tasked to do two proofs of concept with Postgres on Amazon RDS, one with
postgres_fdw and another one with BDR (bi-directional replication extension). After many searches on the internet, it seems to be not possible to do either the
replication or setting up
postgres_fdw on RDS.
However, someone on the internet (I cannot find the reference) mentioned EC2 as a possible way of creating Postgres Foreign DataWrapper or even building replication from a Postgres DB, let's call it
Frankfurt, to connect to a second Postgres instance that we will call
Can anyone confirm that both setting up
postgres_fdw and also
BDR can be set in EC2?