Re: PostgreSQL server won't start, corrupt?

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(dot)klaver(at)aklaver(dot)com