From: | "Rajaram J" <rajarj(at)hotmail(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off |
Date: | 2007-08-19 08:18:17 |
Message-ID: | BAY121-DAV1684B28D976B02F1A533CACFDA0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Rajaram J | 2007-08-19 10:25:46 | Re: FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off |
Previous Message | David Monarchi | 2007-08-18 15:08:24 | Re: ERROR: relation with OID XXXX does not exist |