Re: postgres doesn't start after crash - Mailing list pgsql-general

From Craig Ringer
Subject Re: postgres doesn't start after crash
Date
Msg-id 4AE189E1.5050201@postnewspapers.com.au
Whole thread Raw
In response to Re: postgres doesn't start after crash  (Sam Jas <samjas33@yahoo.com>)
List 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 by date:

Previous
From: Kareem Sedki
Date:
Subject: How to check whether a data type can be cast to another
Next
From: "Jayaraman, Rajaram (STSD)"
Date:
Subject: Re: FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so