Tom Lane wrote:
You can zap just the failed block by turning on "zero_damaged_pages";
that will at least allow you to recover the rest of the table. If you
want to try harder, you could look at the damaged page with pg_filedump
(http://sources.redhat.com/rhdb/) or a similar tool and try to intuit
I get the following error message when doing a select on a table:
ERROR: invalid page header in block 295 of relation "reported_titles"
I found some messages that said this means a block of this table is
corrupt. I found some suspicious lines in the server log just before:
ERROR: could not acc
Tom Lane wrote:
I tried to replicate this, and could not: the restore went into the
expected database. (But I did notice that pg_restore needed to be
explicitly told -Ft, which seems less than bright of it.) Are you
sure those are the exact commands you issued? Were you using the 7.3
versions
I am upgrading my PostgreSQL install from 7.2.3 to 7.3.1. I ran into a
problem with pg_restore creating the database. I am not sure if this is
a documentation problem or a real bug. I have one database with BLOBs
and used tar format backup: "pg_dump -Ft -b mpmx > backup.tar".
I saw the -C op
