pgAdmin Foreign data wrapper error when translating host name to address

Question

I am trying to create a foreign data wrapper in pgAdmin, everything looks fine in terms of installing the wrapper extension, create a foreign data wrapper server, create a user map, until the very last step 'import foreign schema'.

CREATE SCHEMA AAA

IMPORT FOREIGN SCHEMA PUBLIC
from server xxx
into AAA; 

Error: could not connect to server xxx
Detail: could not translate host name xxx to address: name or service not known
SQL state: 08001

so what's wrong with my hostname?

jjanes · Accepted Answer · 2021-06-09 22:55:54Z

2

The system DNS resolver could not look up the IP address of the hostname because, as it says, "name or service not known". Since 'xxx' is presumably not the real hostname, all I can say is figure out what the real hostname should be and then use it, or bypass DNS by plugging in the IP address directly.

This failure location is expected. None of the preceding steps attempt to contact the server, and so would not realize they were given an invalid one.

answered Jun 9, 2021 at 22:55

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pgAdmin Foreign data wrapper error when translating host name to address

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related