Search Postgresql Archives

Re: invalid OID warning after disk failure

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

 



Gabriel Sánchez Martínez wrote:

> Any suggestions on what sanity checks I should run?  For now I am
> doing reindex and vacuum. I think that forces everything to be read. I
> am assuming that if vacuum completes without error then the table is
> fine. 

The main sanity check is to make sure the disks are now in the recycling
center and you have rebuilt the array with new ones.  Then restore the
whole database in a freshly initdb'd system, and praise yourself that
you were able to get them before it all blew to pieces.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


-- 
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