Andrew Dunstan wrote:
>> Still, that's not a 100% solution because of the cases where we use
>> reconnections to change user IDs --- the required password would
>> (usually) vary. It might be sufficient to forbid that case with
>> parallel restore, though; I think it's mostly a legacy thing anyway.
>
> I didn't know such a thing even existed. What causes it to happen? I
> agree it should be forbidden.
It was the only way to switch users before we had SET SESSION
AUTHORIZATION and SET ROLE and such. But the pg_restore man page says
that -R/--no-reconnect is obsolete, so I'm not sure what the current
behavior really is.