Re: PostgreSQL server won't start, corrupt?

On 09/10/2014 21:30, Rob Flemming 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".
>
> 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

Well, the error messages seem to indicate that there's a problem with
pg_hba.conf, so I'd start by reversing whatever you did there and seeing
if that fixes it.

I'd also use something other than Notepad.... it has a hard time with
non-Windows line endings. Notepad++ is a very good free text editor, for
example.

Hope this helps,

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie