Thread: pg_restore : ident authentication problem

i am running postgres 7.2.1 on two machines running debian. i create a dump
file from one using basic options like:

pg_dump -C -F c -f <<filename>> <<database>>

copy this file to my other machine and run:

pg_restore -C -F c -d template1 <<filename>>

during restoration i get an error message that reads

pg_restore: [archiver (db)] could not reconnect to database FATAL 1: IDENT
authentication failed for user <<username>>

i have at least tried most of the pg_restore options, as well relaxing all
permissions in pg_hba.conf and pg_ident.conf. tried running pg_restore as
different users (i.e. postgres or the future restored database owner). tried
the -W option to manually authenticate. tried -O to override permissions
altogether. tried various combinations using -S <<superuser>>, -r and -X.
the second system is practically a mirror image of the first as lists all
the same users. nevertheless, keep receiving this authentication error
message.

can work around it but would rather understand the problem.
does anyone have the answer?

pablo


_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

On Tue, Sep 10, 2002 at 05:29:26PM +0000, Paul Tuohy wrote:
>
> pg_restore: [archiver (db)] could not reconnect to database FATAL 1: IDENT
> authentication failed for user <<username>>
>
> i have at least tried most of the pg_restore options, as well relaxing all
> permissions in pg_hba.conf and pg_ident.conf. tried running pg_restore as

But did you (a) get rid of ident authentication and (b) remember to
HUP the postmaster?  7.2 and forward don't read the pg_hba.conf file
unless they receive SIGHUP.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110