On Tue, 2023-09-05 at 12:08 -0700, Jeff Davis wrote: > OK, so we could have a built-in FDW called pg_connection that would > do > the right kinds of validation; and then also allow other FDWs but the > subscription would have to do its own validation.
While working on this, I found a minor bug and there's another discussion happening here: https://www.postgresql.org/message-id/e5892973ae2a80a1a3e0266806640dae3c428100.camel%40j-davis.com It looks like that's going in the direction of checking for the presence of a password in the connection string at connection time. Ashutosh, that's compatible with your suggestion that CREATE SUBSCRIPTION ... SERVER works for any FDW that supplies the right information, because we need to validate it at connection time anyway. I'll wait to see how that discussion gets resolved, and then I'll post the next version. Regards, Jeff Davis
