On Wed, Aug 30, 2023 at 9:00 PM Jeff Davis <pg...@j-davis.com> wrote: > > On Wed, 2023-08-30 at 19:11 +0530, Ashutosh Bapat wrote: > > Are you suggesting that SERVERs created with FDW can not be used as > > publishers? > > Correct. Without that, how would the subscription know that the FDW > contains valid postgres connection information? I suppose it could > create a connection string out of the options itself and do another > round of validation, is that what you had in mind?
The server's FDW has to be postgres_fdw. So we have to handle the awkward dependency between core and postgres_fdw (an extension). The connection string should be created from options itself. A special user mapping for replication may be used. That's how I see it at a high level. -- Best Wishes, Ashutosh Bapat
