Re: pg_restore and permissions

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> That should work.

No, it won't because the pg_dumpall script will try to connect as each
user who owns objects in the database.  With ident authorization in
force, the DB rejects these connection requests as falsified.

SET SESSION AUTHORIZATION should have been used instead, but I doubt
Florian has any convenient way to re-do the dump file with that option.

I do not think there is any way to restore such scripts except by
temporarily suspending auth checking for local connections.  (If you
feel too paranoid to do that, you might consider tightening access
permissions on the socket file instead.)

            regards, tom lane