Not able to connect to PostgreSQL in Linux!
Srini (a.srinivasan@chennai.transys.net) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Not able to connect to PostgreSQL in Linux!
Long Description
We installed Redhat Linux 7.0 with iPlanet 4.1 web server for Linux. It is working fine. Now, we are trying to run PostgreSQL on top of that.
We were able to do setup of PostgreSQL. The service is running properly. When we try to connect to DB using 'pgaccess' or 'psql', it is throwing the following error message.
"connection to database failed:
missing or erroneous pg_hba.conf file, see postmaster log for details'
We found that there is no log file for postmaster and the content of present /var/lib/pgsql/data/pg_hba.conf file is
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all localhost 255.255.255.255 trust
Please advise how to get out this problem and your further suggestion for the successful running of PostgreSQL database? .
Sample Code
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
"connection to database failed:
missing or erroneous pg_hba.conf file, see postmaster log for details'We found that there is no log file for postmaster
Time to stop using the -S option then.
and the content of present /var/lib/pgsql/data/pg_hba.conf file is
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all localhost 255.255.255.255 trust
^^^
Must be an IP address.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/