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