Eric Parusel <[EMAIL PROTECTED]> writes:
ok, I can dd, if=/dev/zero of=base/dbnum/tablenum, but how do I figure how where and how much to write over?
Is there an easy to see or calculate offset value for a particular page number? (28393)
dd bs=8k seek=28393 count=1
shutdown postgres cp base/dbnum/tablenum* /somewhere/else dd if=/dev/zero of=base/dbnum/tablenum bs=8k seek=28393 count=1 startup postgres
It worked...! select count(*) from table; now works fine!
I'm currently doing a vacuum then a db dump to confirm there's no other page issues...
Vacuum is aptly reporting: WARNING: relation "table" page 28393 is uninitialized --- fixing
Thanks for your assistance, hopefully this helps someone else in the future a little bit.
I don't know why the problem occurred, but I don't think it's realistic to figure that out easily. (disk, raid, server, os, pgsql, or some combination!)
Eric
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
