Re: postgres doesn't start after crash

2009/10/21 Patrick Brückner <payday81(at)gmail(dot)com>:
> Hi,
>
> after a computer crash my postgres 8.2.14 installation under Windows XP SP3
> doesn't start anymore. Here is the log file:
>
> 2009-10-21 23:57:10 FATAL: could not count blocks of relation
> 1663/68065/68157: Permission denied

> I assume it has something to do with the FATAL: could not count blocks of
> relation 1663/68065/68157: Permission denied error. Is there any chance that
> I can repair the data without doing a backup?

Yep. Most common cause is antivirus software. Don't disable it,
uninstall it and try again (antivir often leaves hooks in the OS that
do "bad things" (TM) and you have to actually uninstall it to fix
this.) Note that sometimes uninstalling doesn't work because many
pieces of bad antivir don't actually uninstall when you tell them to.

The second most common cause is someone clicking around as an admin
changing permissions or copying files about.