"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> When restoring databases with pg_restore with the -C
> option it will connect to template1, set authorization to
> the user that created the database and then reconnect
> as the user that created the database to the new database. this is where the
> trouble starts, from here on
> it trys to set authorization back to the superuser to
> do grant and revoke. this will cause the restore to fail.
Hmm. This is still broken in CVS tip, but I think the correct solution
is just to replace "\connect db user" with "\connect db" everywhere.
This will retain the starting real user authentication throughout the
restore process. We have completely abandoned use of \connect to change
authorization, and this seems just an unintentional hangover from the
old way.
regards, tom lane