This morning I got bitten by the "SELECT INTO" / "CREATE TABLE AS" from tables without OIDs bug in 7.4.1.
Postmaster killed all the backends and restarted - pg was down for 2 seconds. This happened two times within a few minute period. Now I am getting 'invalid page header in block 52979 of relation "pg_attribute"' errors in the postgresql log file. I cannot reindex or view the table at all even as user postgres. I have not tried a manual restart of PG. Although hardware could be an issue I tend to doubt it. This server passed an extensive memory test before going into service and I see no occurrences of this error prior to the crash but several since then. This is a 24x7x365 system. I do have a dump from this morning (I do two per day) but I would prefer to fix the problem with no downtime or data loss. What serious problem is this likely to cause/be causing? What are my options for fixing it? Naturally, quick replies are appreciated - this is making me very nervous. Cheers, Steve ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
