Re: Moving data from FreeBSD to Red Hat - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Moving data from FreeBSD to Red Hat
Date
Msg-id 20020530193412.F26487-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Moving data from FreeBSD to Red Hat  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Scaling with memory & disk planning
Next
From: Emil Eifrem
Date:
Subject: Transactions and constraints