Re: PostgreSQL server won't start, corrupt?
От
Rob Flemming
Тема
Re: PostgreSQL server won't start, corrupt?
Дата
Msg-id
CAFLXUujxRsJguqWz3V46_F9K5Jn1z=FAiRQ0WBZi7ga+y_hGmw@mail.gmail.com
Ответ на
Re: PostgreSQL server won't start, corrupt? (Adrian Klaver)
Список
Дерево обсуждения
PostgreSQL server won't start, corrupt? Rob Flemming <robf.42@gmail.com>
Re: PostgreSQL server won't start, corrupt? Ray Stell <stellr@vt.edu>
Re: PostgreSQL server won't start, corrupt? Raymond O'Donnell <rod@iol.ie>
Re: PostgreSQL server won't start, corrupt? John R Pierce <pierce@hogranch.com>
Re: PostgreSQL server won't start, corrupt? Raymond O'Donnell <rod@iol.ie>
Re: PostgreSQL server won't start, corrupt? John R Pierce <pierce@hogranch.com>
Re: PostgreSQL server won't start, corrupt? Merlin Moncure <mmoncure@gmail.com>
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.klaver@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.klaver@aklaver.com
В списке pgsql-general по дате отправления
