PostgreSQL server won't start, corrupt? - Mailing list pgsql-general

From Rob Flemming
Subject PostgreSQL server won't start, corrupt?
Date
Msg-id CAFLXUugz6HajaLz4u+FTBs410n+qW50ooHohLQN2uY7mPAszVg@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL server won't start, corrupt?
Re: PostgreSQL server won't start, corrupt?
Re: PostgreSQL server won't start, corrupt?
Re: PostgreSQL server won't start, corrupt?
List 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 by date:

Previous
From: Dennis
Date:
Subject: Re: Optimal checkpoint_setting
Next
From: John R Pierce
Date:
Subject: Re: Optimal checkpoint_setting