Eric Parusel <lists(at)globalrelay(dot)net> writes:
> I've got a mucked up page in my db, and I can't complete a database dump
> until a particular page is fixed/removed from the table. :(
> Could someone let me know the proper way to go about making a change
> such as this?:
> 1) Clear the page
> or
> 2) Set the bad items in the page to 'free'
Zeroing the page is the most painless way. dd from /dev/zero will get
it done --- but note that you have to shut down the postmaster meanwhile
to ensure Postgres will see your change.
regards, tom lane