invalid syntax in pg_hba.conf file at line 243, token ''

From: "SALUNKHE,MANDAR (HP-Singapore,ex1)" <mandar(dot)salunkhe(at)hp(dot)com>
To: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: invalid syntax in pg_hba.conf file at line 243, token ''
Date: 2003-04-26 04:57:40
Message-ID: B2CFBDADA593FE4D9BD360111FB7F231068D4DBA@xsg01.sgp.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear Tom,

Installing another postgresql database here. Everything went fine and the
./postmaster -i -D /usr/local/pgsql/data
Command starts the pg server fine too.
But when I go on to create the database with
./createdb -E UNICODE INDB
In
/usr/local/pgsql/bin in cygwin, the following error happens.

parse_hba: invalid syntax in pg_hba.conf file at line 253, token ''
FATAL 1: Missing or erroneous pg_hba.conf file, see postmaster log for
details

As per your advice in an earlier posting, I have restarted the PG SERVER as
well as shutdown and started the server again. But the same error persists.
I had not modified the pg_hba.conf file yet and the only entries there are
the usual ones of:

# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT

local all trust
host all 127.0.0.1 255.255.255.255 trust

BTW, Line 243 of the conf file is
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT
-----> this is line 243
local all trust
host all 127.0.0.1 255.255.255.255 trust

Also I tried the mount command and the files are in binmode.
We are installing Postgresql 7.2 ON Win NT 4 with SP6A WITH CYGWIN. ( I have
installed with this config about 3-4 times on other machines but finding
trouble with this one only).
Please help with your advice.
Thanks

Mandar Salunkhe
HP CDI Team
460 Alexandra Road, PSA Building
Singapore 119963
Phone: 65-63617413 HP Telnet Number: 831-7413
Email: mandar(dot)salunkhe(at)hp(dot)com

----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, April 25, 2003 8:00 AM
To: Doug Silver
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Starting postgres with a password

Doug Silver <dsilver(at)urchin(dot)com> writes:
> I've searched around but didn't see this answered (at least in the
> first 100
> answers!). If the postgres user has a password (in Postgres, not the
system)
> *and* the hba_conf file does not trust the 127.0.0.1 host but requires a
> password, how can you start up Postgresql?

The postmaster doesn't need a password to start. If it can access the data
directory it figures you're authorized to start it.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Browse pgsql-novice by date

  From Date Subject
Next Message Brian Gustin 2003-04-26 05:42:08 building postgre on existing server
Previous Message radha.manohar 2003-04-25 21:45:21 Re: postgresql-7.3 implementation