Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Rajaram JDate: 2007-08-19 10:25:46
Subject: Re: FATAL: no pg_hba.conf entry for host "???", user "rajaram", database "template1", SSL off
Previous:From: David MonarchiDate: 2007-08-18 15:08:24
Subject: Re: ERROR: relation with OID XXXX does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group