Thread: Moving data from FreeBSD to Red Hat

I have some data which I backed up from a FreeBSD machine. In FreeBSD the
DB superuser is pgsql. In Red Hat Linux it is Postgresql.

when i try to use pg_restore to get some data which was in FreeBSD to Red
Hat I get an error.

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"

I even tried creating a user pgsql in the Red Hat machine, but that didn't
help.

Any suggestions?

The file I created was compressed. Do I need to use the ASCII format to
move data across?

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

On Sat, 25 May 2002, Tom Lane wrote:

> 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.


That worked.
It seemed pg_restore gave less output on Red Hat than when I did it on
FreeBSD. Maybe before I specified some type of vervose mode.

> I'd like to see --use-set-session-authorization become the default
> (maybe even the only method) in 7.3.


Got the restore working.
I think that option been the default is fine, but I disagree it should be
the only option. In my case I ended up using an option, I think it was -R,
which just switched the ownership to the user that was loading.