simple remote user access question - pg_hda.conf

Поиск
Список
Период
Сортировка
От tj
Тема simple remote user access question - pg_hda.conf
Дата
Msg-id z7lhb.3716$av5.2517@newsread3.news.pas.earthlink.net
обсуждение исходный текст
Список pgsql-general
I can't seem to get the file configured correctly.


This works:
montgomery@spudbox1: psql mydb

This does NOT work:
montgomery@spudbox1:> psql -h 10.10.10.70 mydb
psql: FATAL 1:  No pg_hba.conf entry for host 10.10.10.70, user montgomery,
database mydb

This does NOT work either:
montgomery@spudbox1:> psql -h 10.10.10.70 mydb -U montgomery
psql: FATAL 1:  No pg_hba.conf entry for host 10.10.10.70, user montgomery,
database mydb

Ok, here's my setup:
host: "spudbox1"; 10.10.10.70 (database server, web server)
database: mydb (7.2.2); postmaster running with "-i".
user:   montgomery (user was created on system, and also in db)

pg_hda.conf:
# TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE
local      all                                          trust
host       all         127.0.0.1     255.255.255.255    trust
host       mydb        10.10.10.*    255.255.255.0      trust



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

Предыдущее
От: "postgres"
Дата:
Сообщение: Indexes, multicolumn or not?
Следующее
От: Eric Tan
Дата:
Сообщение: Re: Does postgresql support HKSCS ?