Search Postgresql Archives

DB Corruption after running out of disk space?

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

 



Here's hoping someone can help me... Overnight, our primary database server (part of a master/slave replication pair) ran out of disk space. I have cleaned up space now, but while performing some VACUUM ANALYZE commands I find that there is some corruption.

I'm getting messages like: ERROR:  missing chunk number 0 for toast value 304627805 in pg_toast_16421

I searched around and previous posts to the mailing list suggested a re-index of the pg_toast.pg_toast_16421 table, which I did to no effect. Still getting the error.

Any suggestions or ideas would be appreciated.

Thanks in advance!

Deven Phillips

[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