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

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

Responses

Browse pgsql-novice by date

  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