Re: parallel restore

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.