0

I am using AWS RDS Posgres DB. I would like to connect Postgres to my SQL Server 2019, so that I can have sql server tables available in foreign table drop down of postgres for querying. As I know, tds_fdw data wrapper is required. When I tried to create tds_fdw extension through super user account in AWS RDS, I got the following error:

ERROR: Extension "tds_fdw" is not supported by Amazon RDS DETAIL: Installing the extension "tds_fdw" failed, because it is not on the list of extensions supported by Amazon RDS. HINT: Amazon RDS allows users with rds_superuser role to install supported extensions. See: SHOW rds.extensions; SQL state: 22023

Is there any way to install tds_fdw on AWS RDS? If not then, what other ways I can use to connect AWS RDS Postgres to my SQL Server?

Improve this question

2 Answers 2

Reset to default
1

If RDS doesn't allow it, then you can't do it on RDS. The straightforward solution is not to use RDS if it doesn't support the features you need.

But RDS does allow postgres_fdw. So the convoluted solution is to run your own postgres server (perhaps running it on an EC2 instance) which does supports tds_fdw, and then connect to that from RDS and chain the foreign tables.

Improve this answer
0

Since Mar 21, 2022 Amazon RDS for PostgreSQL now supports tds_fdw extension for SQL Server Databases, see: https://aws.amazon.com/ru/about-aws/whats-new/2022/03/amazon-rds-postgresql-supports-extension-sql-server-database/

Improve this answer
2
  • Please post the essentials here
    – Rohit Gupta
    Commented Sep 5, 2023 at 8:28
  • As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.
    – Community Bot
    Commented Sep 5, 2023 at 8:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.