pg_dump restore problem - Mailing list pgsql-admin

From Devi Munandar
Subject pg_dump restore problem
Date
Msg-id 025501c2f6a7$1ab78000$a6f0cda7@informatika.lipi.go.id
Whole thread Raw
Responses Re: pg_dump restore problem
List pgsql-admin
Hi admin

i have problem with user authentification

I've made a dump from PostgreSQL 7.2.2 under linux 8.0 with the command:
pg_dump -a -b -Fc -f  bakstore -o -v store

and running success, and then i try to restore with the command:
pg_restore -a -d store -Fc -o -v bakstrore

and running unsuccess because i've got message:
pg_restore:[archiver (db)] could not reconnect to database : FATAL 1 : IDENT
authentification failed for user "phpuser"

my post pg_hba.conf
*****************
TYPE         DATABASE        IP_ADDRESS      MASK
AUTH_TYPE        AUTH_ARGUMENT
host            all                          127.0.0.1
255.255.255.255          trust
host            store                     167.205.240.166   255.255.255.0
trust
host            all                          127.0.0.1
255.255.255.255        ident                    phpuser

my post pg_ident.conf
******************
MAP            IDENT            PGUSERNAME
phpuser        phpuser            postgres

NB: i make 'store' database pass through phpPgAdmin2.4.2 with
username:"phpuser" and password:""

Best Regards,

--devi munandar


pgsql-admin by date:

Previous
From: Andrew Biagioni
Date:
Subject: Re: Hope it's ok to post a pgAdmin request for help in this list...
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_dump restore problem