On Fedora 37 with a default install of PostgreSQL 14.3 the steps in the example fail as it can't open the network connection due to the restrictive SELinux policy.
With the default policy a query on a fdw table returns error 13 (permission denied).
This can be fixed by running sudo semanage permissive -a postgresql_t
It might be enough to put a notice in there about checking (or disabling) SELinux. It might not be obvious to many that SELinux is causing the failure.
On Fedora 37 with a default install of PostgreSQL 14.3 the steps in the example fail as it can't open the network connection due to the restrictive SELinux policy.
With the default policy a query on a fdw table returns error 13 (permission denied).
This can be fixed by running
sudo semanage permissive -a postgresql_t
It might be enough to put a notice in there about checking (or disabling) SELinux. It might not be obvious to many that SELinux is causing the failure.