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: (view raw or whole 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      
"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,

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-2017 The PostgreSQL Global Development Group