Re: postgres doesn't start after crash

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Sam Jas <samjas33(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Patrick Brückner <payday81(at)gmail(dot)com>
Subject: Re: postgres doesn't start after crash
Date: 2009-10-23 10:48:01
Message-ID: 4AE189E1.5050201@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jayaraman, Rajaram (STSD) 2009-10-23 10:51:27 Re: FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so
Previous Message Jayaraman, Rajaram (STSD) 2009-10-23 10:39:43 Re: FATAL error "could not find function "alt_to_mic" in file cyrillic_and_mic.so