Search Postgresql Archives

Re: Corrupted DB? could not open file pg_clog/####

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jul 31, 2006 at 06:09:33PM -0400, Francisco Reyes wrote:
> Martijn van Oosterhout writes:
> 
> >That's when you've reached the end of the table. The point is that
> >before then you'll have found the value of N that produces the error.
> 
> Will be a while.. my little python script is doing under 10 selects/sec... 
> and there are nearly 67 million records. :-(

Naturally you'd do a binary search. That'd take a maximum of about
log2(67 million) = about 26 scans.

Once you find it you should be able to identify the ctid. You may be
able to delete it.

> >It will rollback all pending transactions. The point is that it's
> >looking for information about transactions that were committed. This is
> >usually a memory or disk error.
> 
> So, should it be safe to create the file and fill it up with 256K zeros?

For a certain value of "safe". It get the system running, but there's
no guarentees about the data in it...

> At the rate my script is going.. it's going to take a very long time to 
> find out where the problem is. If I have a dump.. any usefull info I can 
> take from the point the dump stopped?

That gives you the place in the file where it broke...

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux