Search Postgresql Archives

Re: vacuumdb: vacuuming of database "xy" failed: PANIC: corrupted item pointer: 19227

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

 



2009/11/18 Tech 2010 <tch072@xxxxxxxxx>:
> Hello!
>
> How do I location of this pointer and how do I zero it so I can access
> the rest of the data?
>
> "zero_damaged_pages = true" did not help in this case, because I
> always get same numbers being zeroed. This is with 8.4.0 and 8.4.1.
>
> Thanks.
>

You probably just need to reindex a table.  Try vacuuming each table
individually until you get this error, or just check the vacuum log
output to identify it, then just run a REINDEX on it.

Regards

Thom

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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