CREATE SUBSCRIPTION can get its connection settings from a foreign server, such as one defined with postgres_fdw.
CREATE SUBSCRIPTION
postgres_fdw