Can't get pg_hba.conf to work

From: Doug Silver <dsilver(at)urchin(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can't get pg_hba.conf to work
Date: 2002-06-26 18:20:59
Message-ID: Pine.LNX.4.21.0206261115000.22273-100000@danzig.sd.quantified.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sharon Cowling 2002-06-26 22:50:00 Date Question
Previous Message Josh Berkus 2002-06-26 18:17:33 Re: [OT] OOo postgres connection