Re: PostgreSQL server won't start, corrupt?

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: PostgreSQL server won't start, corrupt?
Дата
Msg-id CAHyXU0xwZ1E0tsDLd+3-7SBXdexQNPt6J9wQLUiX9d_XPds63A@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL server won't start, corrupt?  (Rob Flemming <robf.42@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Nick Barnes
Дата:
Сообщение: FK check implementation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: FK check implementation