Re: Moving data from FreeBSD to Red Hat

Francisco Reyes <lists@natserv.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