Re: pg_restore authentication failure

Поиск
Список
Период
Сортировка
От Patrick Welche
Тема Re: pg_restore authentication failure
Дата
Msg-id 20021004165504.H27710@quartz.newn.cam.ac.uk
обсуждение исходный текст
Ответ на pg_restore authentication failure  (Zeno Davatz <zdavatz@ywesee.com>)
Список pgsql-general
On Wed, Oct 02, 2002 at 04:35:28PM +0200, Zeno Davatz wrote:
> Hi List
>
> I done a pg_dumpall and now would like to load the data back into my new
> database. I am doing:
>
> psql -e nachahmer < /home/ywesee/pgsql/pgsqldump.sql
>
> And get:
> ERROR:  Language plpgsql already exists
> \connect: FATAL 1:  IDENT authentication failed for user "nachahmer"
>
>  at the end of the message. Do you have any idea what could be wrong?
>
> My pg_hba.conf is:
> local      all                                          trust
> host       all         127.0.0.1     255.255.255.255    trust

I think there is a new USER column in pg_hba.conf.
cf src/backend/libpq/pg_hba.conf.sample

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
local   all         all                                             trust
host    all         all         127.0.0.1         255.255.255.255   trust


Cheers,

Patrick

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: speed of server side languages
Следующее
От: Patrick Welche
Дата:
Сообщение: Re: Creating resultsets