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