Re: PostgreSQL server won't start, corrupt?

You were right! (Of course, you knew that.)

I typed a new pg_hba.conf from scratch without all the comments, i.e. only
the connection strings, it worked.

Thank you 'Community'!

(Doh! My kids think I'm so smart because I work on computers, some day
they'll discover the truth. Now to spend the afternoon backing up that
data...)

On 9 October 2014 14:25, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> 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
>