Re: how do I clear a page, or set an item in a page to 'free'? - Mailing list pgsql-general

Eric Parusel <lists@globalrelay.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