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
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.. |