Thread: RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !

RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !

From
"Mikheev, Vadim"
Date:
> Then if I reindex my DB I have :
> 
> NOTICE:  --Relation astro--
> NOTICE:  Pages 204: Changed 0, reaped 0, Empty 0, New 0; Tup 
> 4878: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 324, MaxLen 324;
> Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU
0.04s/0.18u sec.
> NOTICE:  Index astro_pkey: Pages 25; Tuples 4878. CPU 0.01s/0.01u sec.
> 
> If I do :
>   select * from astro;
> 
> I have :
> 
...
> (0 rows)

Well, it may be caused by corrupted next_xid in pg_variable.
Could you

CREATE TABLE foo (bar int);
select xmin from pg_class where relname = 'foo';

and say what is exact size of pg_log file?

Vadim