Thread: invalid syntax in pg_hba.conf file at line 243, token ''
invalid syntax in pg_hba.conf file at line 243, token ''
From
"SALUNKHE,MANDAR (HP-Singapore,ex1)"
Date:
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.salunkhe@hp.com ----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Friday, April 25, 2003 8:00 AM To: Doug Silver Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Starting postgres with a password Doug Silver <dsilver@urchin.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