Share via

Azure PostgreSQL Single Server can't connect to PostgreSQL Flexible Server via postgres_fdw?

fyzhu_henk 1 Reputation point
2022-06-15T14:58:12.767+00:00

We created a single server postgresql and a flexible server postgresql that single server can not connect to flexible server via postgres_fdw and get the following message when I run "IMPORT FOREIGN SCHEMA public LIMIT TO ( abc_test ) FROM SERVER server_name INTO public".

Query 1 ERROR: ERROR: could not connect to server "server_name"
DETAIL: could not connect to server: Network is down (0x00002742/10050)
Is the server running on host "host.name" (xxx.xx.xx.xx) and accepting
TCP/IP connections on port 5432?

I confirmed that both of the firewalls were set to 0.0.0.0 - 255.255.255.255 and also checked "Allow access to Azure services".

Is there any solution for it?

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,502 Reputation points Microsoft Employee
    2022-06-17T17:58:27.503+00:00

    Hi, @fyzhu_henk Thanks for your patience, I got a confirmation from the engineering team that this scenario is not supported and you should upgrade the existing Single Server PG to Flexible and try FDW between flex to flex.

    Please let me know if this information is helpful.

    Regards
    Geetha

    0 comments

Your answer

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