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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 |