| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Gabriel Sánchez Martínez <gabrielesanchez(at)gmail(dot)com> |
| Cc: | Raghu Ram <raghuchennuru(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: invalid OID warning after disk failure |
| Date: | 2014-11-17 14:46:54 |
| Message-ID: | 20141117144654.GY1791@alvin.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2014-11-17 16:40:48 | Re: Managing Key Value tags on rows |
| Previous Message | Gabriel Sánchez Martínez | 2014-11-17 13:17:50 | Re: invalid OID warning after disk failure |