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

From Tom Lane
Subject Re: how do I clear a page, or set an item in a page to 'free'?
Date
Msg-id 547.1111428254@sss.pgh.pa.us
Whole thread Raw
In response to how do I clear a page, or set an item in a page to 'free'?  (Eric Parusel <lists@globalrelay.net>)
Responses Re: how do I clear a page, or set an item in a page to
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

pgsql-general by date:

Previous
From: Alex Adriaanse
Date:
Subject: Re: Tracking row updates
Next
From: Jay Guerette
Date:
Subject: Re: Copression