Brad Nicholson wrote:
> We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
> switch out while it was under load), which caused the DB to crash. It
> started up fine, when I vacuumed the DB, I saw the following messages.
>
> WARNING: relation "my_table" page 652139 is uninitialized --- fixing
> WARNING: relation "my_table" page 652140 is uninitialized --- fixing
> WARNING: relation "my_table" page 652940 is uninitialized --- fixing
> WARNING: relation "my_table" page 652941 is uninitialized --- fixing
>
> That sort of looks like it could be data loss, can someone explain what
> happened?
It means someone extended the table, but didn't get around to actually
putting tuples on it and committing. Four transactions were doing this
when the system crashed. No committed data was lost.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support