On 9/23/23 03:57, Jeff Davis wrote:
> IIUC there is really one use case here, which is for superuser to
> define a subscription including the connection, and then change the
> owner to a non-superuser to actually run it (without being able to
> touch the connection string itself). I'd just document that in its own
> section, and mention a few caveats / mistakes to avoid. For instance,
> when the superuser is defining the connection, don't forget to set
> password_required=false, so that when you reassign to a non-superuser
> then the connection doesn't break.
Hi,
I tried adding a section in "Logical Replication > Subscription" with
the text you suggested and links in the CREATE / ALTER SUBSRIPTION commands.
Is it better ?
--
Benoit Lobréau
Consultant
http://dalibo.com