Tom Lane wrote:
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 postgr
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Wouldn't zero_damaged_pages help here?
Only if there's detectable corruption in the page header, which there
seems not to be.
regards, tom lane
---(end of broadcast)---
TIP 1: subs
Scott Marlowe <[EMAIL PROTECTED]> writes:
> ahh, ok. I just know I'm much more nervous about zeroing stuff by hand
> than letting the backend do it for me.
Well, I certainly hope Eric is gonna save aside a copy of the file
(if not the whole database) before he hacks it ;-)
BTW, I missed the poin
ahh, ok. I just know I'm much more nervous about zeroing stuff by hand
than letting the backend do it for me.
On Mon, 2005-03-21 at 13:54, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > Wouldn't zero_damaged_pages help here?
>
> Only if there's detectable corruption in the page
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
Wouldn't zero_damaged_pages help here?
http://www.postgresql.org/docs/7.4/static/runtime-config.html#RUNTIME-CONFIG-DEVELOPER
On Mon, 2005-03-21 at 13:28, Eric Parusel wrote:
> Tom Lane wrote:
> > Eric Parusel <[EMAIL PROTECTED]> writes:
> >
> >>I've got a mucked up page in my db, and I can't co
Tom Lane wrote:
Eric Parusel <[EMAIL PROTECTED]> 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. :(
Zeroing the page is the most painless way. dd from /dev/zero will get
it done --- but note that you have to
Eric Parusel <[EMAIL PROTECTED]> 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)
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'
I can see the
