pg_dump restore problem
От | Devi Munandar |
---|---|
Тема | pg_dump restore problem |
Дата | |
Msg-id | 025501c2f6a7$1ab78000$a6f0cda7@informatika.lipi.go.id обсуждение исходный текст |
Ответы |
Re: pg_dump restore problem
|
Список | 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 по дате отправления: