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.kla...@aklaver.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.kla...@aklaver.com >
