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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group