PostgreSQL server won't start, corrupt?

Поиск
Список
Период
Сортировка
От Rob Flemming
Тема PostgreSQL server won't start, corrupt?
Дата
Msg-id CAFLXUugz6HajaLz4u+FTBs410n+qW50ooHohLQN2uY7mPAszVg@mail.gmail.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?  (Ray Stell <stellr@vt.edu>)
Re: PostgreSQL server won't start, corrupt?  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Hi I've had a a PostgreSQL 9.3 server running on Windows 7 for several months.  

While trying to diagnose a remote computer's connection problem (through ArcGIS, grrr), i was clicking through the postgres (data) directory  and opened a couple of files using Notepad but promptly closed them without making any changes.  e.g. "C:\postgres\pg_clog\0000" and "C:\postgres\pg_stat\global.stat".

I added a line to the "pg_hba.conf" file and tried to restart the server, but now it will not run!

The messages in the log file are:
    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

I am afraid something was corrupted, especially based on the info. here: <https://wiki.pscs.co.uk/how_to:postgresql_server_won_t_start_due_to_damaged_log_files>

What can I do to restart?

Thank you,
Rob

В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis
Дата:
Сообщение: Re: Optimal checkpoint_setting
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Optimal checkpoint_setting