Francisco Reyes <lists(at)natserv(dot)com> writes:
> bash-2.05$ pg_restore -d temp -U postgres -S postgres bestpal.dump
> pg_restore: [archiver (db)] could not reconnect to database: FATAL 1:
> IDENT authentication failed for user "pgsql"
Try it with --use-set-session-authorization. Alternatively, back off
the pg_hba setting to "trust" (or something pretty weak anyway) to run
the restore.
I'd like to see --use-set-session-authorization become the default
(maybe even the only method) in 7.3.
regards, tom lane