Can't get pg_hba.conf to work - Mailing list pgsql-novice

From Doug Silver
Subject Can't get pg_hba.conf to work
Date
Msg-id Pine.LNX.4.21.0206261115000.22273-100000@danzig.sd.quantified.net
Whole thread Raw
Responses Re: Can't get pg_hba.conf to work  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Can someone please point out the folly of my ways?

Here's my setup, FBSD 4.6, postgresql-7.2.1_1 with the pgsql user as
follows:

Login: pgsql                      Name: PostgreSQL Daemon
Directory: /var/db/pgsql                Shell: /bin/sh


#    ll /var/db/pgsql/data/
total 26
drwx------   6 pgsql  pgsql    512 Jun 26 11:13 ./
drwxr-x---   6 pgsql  pgsql    512 Jun 26 11:06 ../
-rw-------   1 pgsql  pgsql      4 Jun  2 12:42 PG_VERSION
drwx------  12 pgsql  pgsql    512 Jun  8 15:39 base/
drwx------   2 pgsql  pgsql    512 Jun 26 11:16 global/
drwx------   2 pgsql  pgsql    512 Jun  2 12:42 pg_clog/
-rw-------   1 pgsql  pgsql  10879 Jun 26 10:58 pg_hba.conf
-rw-------   1 pgsql  pgsql   1250 Jun  2 12:42 pg_ident.conf
drwx------   2 pgsql  pgsql    512 Jun 25 16:00 pg_xlog/
-rw-------   1 pgsql  pgsql   3865 Jun  5 17:40 postgresql.conf
-rw-------   1 pgsql  pgsql     31 Jun  5 17:30 postmaster.opts
-rw-------   1 pgsql  pgsql     45 Jun  5 17:30 postmaster.pid

And no matter what I put in the pg_hba.conf file, I get the following:
parse_hba: invalid syntax in pg_hba.conf file at line 253, token
"localhost"
FATAL 1:  Missing or erroneous pg_hba.conf file, see postmaster log for
details

Line 253 is commented out, there is no 'localhost' in the file.  I can
connect locally, but I need to setup client access.

Here's the lines I need to work:
# TYPE     DATABASE    IP_ADDRESS    MASK               AUTH_TYPE  AUTH_ARGUMENT
local       all                                            trust
host        all         127.0.0.1      255.255.255.255     trust
host        all         63.212.175.55  255.255.255.255     crypt
host        test        63.212.175.99  255.255.255.255     crypt
host        all         0.0.0.0        0.0.0.0             reject


TIA!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Urchin Software Corp.    http://www.urchin.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~




pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [OT] OOo postgres connection
Next
From: Sharon Cowling
Date:
Subject: Date Question