Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>> BTW, I think it's well past time to make pg_dump use SET SESSION
>> AUTHORIZATION by default, or even always, instead of \connect commands.
> Well, the tradeoff is "restoring user has to be superuser" vs "restoring
> user has to know everyone's authentication secrets". The former is
> obviously more likely.
Hmm, good point. But we could ease this if the system allowed
"SET SESSION AUTHORIZATION <myself>" to non-superusers. Then a
pg_dump of your own stuff would still restore without trouble.
A pg_dump of multiple people's stuff is superuser territory anyway.
regards, tom lane