FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off

Поиск
Список
Период
Сортировка
От Rajaram J
Тема FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off
Дата
Msg-id BAY121-DAV1684B28D976B02F1A533CACFDA0@phx.gbl
обсуждение исходный текст
Список pgsql-novice
Hi

I built PostGreSql 7.4.17 on HP-UX 11.23 m/c IA m/c.

After compilation when i do a gmake check as a diff user as recomended i get
the message


============== creating database "regression"         ==============
createdb: could not connect to database template1: FATAL:  no pg_hba.conf
entry for host "???", user "rajaram", database "template1", SSL off
pg_regress: createdb failed
gmake[2]: *** [check] Error 2
gmake[2]: Leaving directory `/postgresql/postgresql-7.4.17/src/test/regress'
gmake[1]: *** [check] Error 2
gmake[1]: Leaving directory `/postgresql/postgresql-7.4.17/src/test'
gmake: *** [check] Error 2


my pg_hba.conf entry is

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

# IPv4-style local connections:
host all         all         127.0.0.1          255.255.255.255
trust

# IPv6-style local connections:
host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust


the message in the postmaster.log file is
....
FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database
"template1", SSL off
FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database
"template1", SSL off
FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database
"template1", SSL off
FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database
"template1", SSL off
FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database
"template1", SSL off
FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database
"template1", SSL off
FATAL:  no pg_hba.conf entry for host "???", user "rajaram", database
"template1", SSL off
LOG:  received fast shutdown request
LOG:  shutting down
LOG:  database system is shut down



when i added one more entry to the file pg_hba.conf
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
local   all         all                                             trust

# IPv4-style local connections:
host all         all         127.0.0.1          255.255.255.255
trust
host all         all         15.11.135.124          255.255.255.255
trust

# IPv6-style local connections:
host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust



createdb: could not connect to database template1: FATAL:  no pg_hba.conf
entry for host "???", user "rajaram", database "template1", SSL off

the message in the postmaster.log file is the same


I have ran out of options, Can any one please help.

Regards

Rajaram J


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

Предыдущее
От: "David Monarchi"
Дата:
Сообщение: Re: ERROR: relation with OID XXXX does not exist
Следующее
От: "Rajaram J"
Дата:
Сообщение: Re: FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off