Steven Mezzadri wrote:
> The database for our moodle web site (uses PHP/postgres 8.1.11/Linux) has
> stopped working. The server froze yesterday and we had to cycle power to
> resolve the issue. Now the postgresql service will not start. I tried a
> backup from last week and get the same result. I have no other backups or
> dumps. I have tried running fsck. The disks are in a RAID-1 array and
> neither disk has failed. I did not run out of RAM or disk space.
> -bash-3.2$ tail postgresql-Fri.log
> ERROR: could not open relation 1663/16384/435720012: No such file or
> directory
> CONTEXT: writing block 1 of relation 1663/16384/435720012
> WARNING: could not write block 1 of 1663/16384/435720012
> DETAIL: Multiple failures --- write error may be permanent.
Ugh.
What filesystem is this using? Sounds like it lost a file. Maybe it
ended up in lost+found or something?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support