Re: PostgreSQL server won't start, corrupt?

On Thu, Oct 9, 2014 at 3:30 PM, Rob Flemming <robf(dot)42(at)gmail(dot)com> wrote:
> 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".

Any change to clog files would indeed corrupt the database. It sounds
to me like you have a mundane pg_hba.conf problem -- no big deal! Fix
it and start taking regular backups.

merlin