Re: authentication error

Поиск
Список
Период
Сортировка
От Gémes Géza
Тема Re: authentication error
Дата
Msg-id 3EC2A5EF.30101@kzsdabas.sulinet.hu
обсуждение исходный текст
Ответ на authentication error  (jie zhang <jie@best.com>)
Список pgsql-admin
jie zhang írta:

> Hi,
>
> I try to connect using psql test from localhost.  I got:
> FATAL 1:  No pg_hba.conf entry for host localhost, user postgres,
> database test
>
> I double checked that I have done the following:
> I started server using: postmaster -i -D /var/lib/pgsql/data >logfile
> 2>&1 &
>
> In my pg_hba.conf file I have:
> host       all         127.0.0.1     255.255.255.0    trust
> local   all     reject
>
> Are there anything else I need to do ?  or anything I did wrong ?
> I try to force the connection go through tcp/ip.
> Please advice if you can.
> thanks in advance,
>
> Jie
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Can you connect without a host option if yes then check your
postgresql.conf file (should be in the same dir as pg_hba.conf)  check
for a line tcpip_socket = true if not found write it and then restart
the postmaster.

Good luck

Geza Gemes



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

Предыдущее
От: jie zhang
Дата:
Сообщение: authentication error
Следующее
От: Bruno Mattarollo
Дата:
Сообщение: [URGENT] Problems recovering database