Re: postgres doesn't start after crash

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: postgres doesn't start after crash
Дата
Msg-id 4AE189E1.5050201@postnewspapers.com.au
обсуждение исходный текст
Ответ на Re: postgres doesn't start after crash  (Sam Jas <samjas33@yahoo.com>)
Список pgsql-general
Sam Jas wrote:
>
> Did you find what the reason of crash was?
>
> Log seems that the data is corrupted as the system was crashed.

The "permission denied" error would suggest that if anything was
corrupted, it was file-system metadata. That shouldn't happen on NTFS,
though.

It's more likely that for some reason (as previously suggested: quite
possibly AV software) the WAL file creation hit disk, but the result of
the system call setting its permissions never did.

It's quite likely that if you get "properties" on the postgresql data
directory and use the security tab to grant "full control" to the
postgresql user account then apply that change recursively you may be
able to start PostgreSQL.

--
Craig Ringer

В списке pgsql-general по дате отправления:

Предыдущее
От: Kareem Sedki
Дата:
Сообщение: How to check whether a data type can be cast to another
Следующее
От: "Jayaraman, Rajaram (STSD)"
Дата:
Сообщение: Re: FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so