| From: | Francisco Reyes <lists(at)natserv(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Moving data from FreeBSD to Red Hat |
| Date: | 2002-05-30 23:35:03 |
| Message-ID: | 20020530193412.F26487-100000@zoraida.natserv.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 25 May 2002, Tom Lane wrote:
> 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.
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emil Eifrem | 2002-05-30 23:54:05 | Transactions and constraints |
| Previous Message | Scott Marlowe | 2002-05-30 22:34:23 | Re: Scaling with memory & disk planning |