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

From Merlin Moncure
Subject Re: PostgreSQL server won't start, corrupt?
Date
Msg-id CAHyXU0xwZ1E0tsDLd+3-7SBXdexQNPt6J9wQLUiX9d_XPds63A@mail.gmail.com
Whole thread Raw
In response to PostgreSQL server won't start, corrupt?  (Rob Flemming <robf.42@gmail.com>)
List pgsql-general
On Thu, Oct 9, 2014 at 3:30 PM, Rob Flemming <robf.42@gmail.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


pgsql-general by date:

Previous
From: Nick Barnes
Date:
Subject: FK check implementation
Next
From: Tom Lane
Date:
Subject: Re: FK check implementation