On 10/09/2014 02:16 PM, Rob Flemming wrote:
> I think that pg_hba.conf is a bit of a red herring, the first line of
> the log file is probably more important (?):
> PDT LOG: invalid connection type ""
No pg_hba.conf is where the issue is. From your original post:
2014-10-09 12:59:40 PDT LOG: invalid connection type ""
2014-10-09 12:59:40 PDT CONTEXT: line 1 of configuration file
"C:/postgres/pg_hba.conf"
2014-10-09 12:59:40 PDT FATAL: could not load pg_hba.conf
Note the CONTEXT line that places the error in pg_hba.conf. Also the
next line that shows that pg_hba.conf is not loaded. Somehow you have
entered something on the first line that Postgres thinks is a connection
specification.
>
> (I changed the file to Unix format anyway, just to rule that out).
>
--
Adrian Klaver
adrian.klaver@aklaver.com