Share via

Cross Database Query suport for Azure Database for PostgreSQL

24573417 1 Reputation point
2021-11-15T10:48:02.267+00:00

I am interested to know if Cross DB queries are supported for Azure Database for PostgreSQL?
I understand that Elastic Query Tools does provide capability to query cross DB Azure SQL DB, but is ot possible to acheive the similar functionality for Azure Database for PostgreSQL?

Scenario 1 - Multiple Azure Database for PostgreSQL hosted on a single server
Scenario 2 - Multiple Azure Database for PostgreSQL hosted on a different server

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator
    2021-11-18T01:57:40.857+00:00

    Hi @24573417

    For scenario 1 You will need to install the postgres_fdw extensions. https://learn.microsoft.com/en-us/azure/postgresql/concepts-extensions#dblink-and-postgres_fdw
    make sure Allow access to Azure services" to ON
    150421-image.png

    Does not apply for scenario 2

    Please let me know if you have further queries

    Regards,
    Oury

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.