Re: Questions about the new subscription parameter: password_required

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