Skip site navigation (1) Skip section navigation (2)

Re: emergencia

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Gustavo Rosso <grosso(at)sadaic(dot)org(dot)ar>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: emergencia
Date: 2009-04-28 14:22:20
Message-ID: 20090428142220.GJ10358@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Gustavo Rosso escribió:
> Gente estoy en problemas.
> Me aparecio hoy una tabla dañada, un select da este error:
>
> ERROR:  could not read block 518 of relation 1663/16384/2002069: read  
> only 4096 of 8192 bytes

A todo esto, la forma de saber qué tabla es esta es la siguiente:

select oid::regclass from pg_class where relfilenode = 2002069;

-- 
Alvaro Herrera                http://www.amazon.com/gp/registry/3BP7BYG9PUGI8
"How strange it is to find the words "Perl" and "saner" in such close
proximity, with no apparent sense of irony. I doubt that Larry himself
could have managed it."         (ncm, http://lwn.net/Articles/174769/)

In response to

  • emergencia at 2009-04-28 13:39:29 from Gustavo Rosso

pgsql-es-ayuda by date

Next:From: Gustavo RossoDate: 2009-04-28 14:25:59
Subject: Re: Error
Previous:From: Emanuel Calvo FrancoDate: 2009-04-28 14:14:27
Subject: Re: Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group