Search Postgresql Archives

Re: postgres doesn't start after crash

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2009/10/21 Patrick Brückner <payday81@xxxxxxxxx>:
> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux