AWS POSTGRESQL RDS FDW MANUAL
I did a quick search around and I haven't been able to find any references to anyone actually layering foreign data wrappers like this but I also couldn't find anything in the manual or online saying it wasn't supported either. But it might be worth testing to see if it works for your use case. So does Amazon RDS, OpenShift and list goes on. Core PostgreSQL engine features For a detailed list of PostgreSQL core engine features, please refer here. Now, when I tries to make connection from Azure to AWS it says the host is invalid. ntrol needs to be installed into share/postgresql/extension/ in order to be able to run psql. Foreign data wrappers The postgresfdw extension lets you access and modify data stored in other PostgreSQL servers as if they were tables within the Amazon RDS for PostgreSQL DB Instance. Now, one of my RDS has been moved from AWS to Azure. If the amount of data you're retrieving is substantial, or if the number of queries per minute is high this is probably a terrible idea. I was using FDW extension in PostgreSQL from 2 years to load data from one database to another database. The only alternative to this I can think of is that you may be able to host a different (otherwise empty) PostgreSQL server with the oracle-fdw extension installed and use the postgres-fdw extension (which is supported by RDS) to proxy requests from your RDS hosted database, through your proxy PostgreSQL database, to your Oracle database and back. This will certainly work but will require some leg work to replace what you're losing by not using RDS. You lose automatic backup/replication/management features, but you get the power and flexibility you need.
Like you mentioned, the general option in this case would be to host PostgreSQL yourself on EC2 instead of RDS. As far as I'm aware there's no way around this limitation. With PostgreSQL on Amazon RDS your choice of extensions is limited to the extensions they explicitly support.
0 kommentar(er)
