pg_dump restore problem

From: "Devi Munandar" <devi(at)informatika(dot)lipi(dot)go(dot)id>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump restore problem
Date: 2003-03-30 10:28:28
Message-ID: 025501c2f6a7$1ab78000$a6f0cda7@informatika.lipi.go.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-03-30 13:45:42 Re: pg_dump restore problem
Previous Message Tarry Singh 2003-03-29 17:05:25 net start postmaster doesn't start....I've checked the archives already..