Re: Can't get pg_hba.conf to work - Mailing list pgsql-novice

From Tom Lane
Subject Re: Can't get pg_hba.conf to work
Date
Msg-id 16632.1025133112@sss.pgh.pa.us
Whole thread Raw
In response to Can't get pg_hba.conf to work  (Doug Silver <dsilver@urchin.com>)
Responses Re: Can't get pg_hba.conf to work
List pgsql-novice
Doug Silver <dsilver@urchin.com> writes:
> 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

In 7.2 you must SIGHUP the postmaster to get it to take notice of
changes in its config files --- the thing is still complaining about
an error in whatever the file contained when you started it.

"pg_ctl reload" is a convenient script for sending SIGHUP to the
postmaster.

            regards, tom lane



pgsql-novice by date:

Previous
From: Sharon Cowling
Date:
Subject: Date Question
Next
From: Doug Silver
Date:
Subject: Re: Can't get pg_hba.conf to work