FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off - Mailing list pgsql-novice

From Rajaram J
Subject FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off
Date
Msg-id BAY121-DAV1684B28D976B02F1A533CACFDA0@phx.gbl
Whole thread Raw
List 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 by date:

Previous
From: "David Monarchi"
Date:
Subject: Re: ERROR: relation with OID XXXX does not exist
Next
From: "Rajaram J"
Date:
Subject: Re: FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off