The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/postgres-fdw.html Description:
The documentation page for postgres_fdw <https://www.postgresql.org/docs/current/postgres-fdw.html> gives a nice step by step on what's needed to configure a FOREIGN SERVER. However, one crucial step is missed, and that is that you need to issue GRANT USAGE ON FOREIGN SERVER before you can successfully run step 4, IMPORT FOREIGN SCHEMA. Fortunately, I was able to get help on this from some kind folks in #postgresql on IRC, but the documentation should be updated to include this step. Thanks, --Joe