pg_dump restore problem

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

Предыдущее
От: Andrew Biagioni
Дата:
Сообщение: Re: Hope it's ok to post a pgAdmin request for help in this list...
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_dump restore problem