Can't get pg_hba.conf to work
От | Doug Silver |
---|---|
Тема | Can't get pg_hba.conf to work |
Дата | |
Msg-id | Pine.LNX.4.21.0206261115000.22273-100000@danzig.sd.quantified.net обсуждение исходный текст |
Ответы |
Re: Can't get pg_hba.conf to work
|
Список | 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 по дате отправления: