Thread

1. Not able to connect to PostgreSQL in Linux!

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-02-19T16:00:20Z

   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
   
   
   

2. Re: Not able to connect to PostgreSQL in Linux!

   Peter Eisentraut <peter_e@gmx.net> — 2001-02-19T17:26:22Z

   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/