Gregory Stark wrote:
"Gerardo Herzig" <[EMAIL PROTECTED]> writes:
Hi all. Well, im having this problem for the first time.
When executing a VACUUM, i have this msg:
gse_new_version=# VACUUM ;
ERROR: could not access status of transaction 118
DETAIL: could not open file "pg_clog/0000": No existe el fichero o el
directorio
[]
Ok, wtf, i will create the file. So touch pg_clog/0000 and VACUUM again....
ERROR: could not access status of transaction 118
DETAIL: could not read from file "pg_clog/0000" at offset 0: Conseguido
That's almost the right idea for a last ditch attempt to extract what data you
can from a corrupted table. You have to fill the file with nul bytes though.
Something like dd if=/dev/zero of=0000 bs=1k count=nnn where nnn is, uh, I'm
not sure how large, it won't take much to cover transactionid 118 though.
Mmmm, yeah, after dd'ing the 0000 file, VACUUM execute just fine!!
BTW, a previous atempt to build a CLUSTER gives me the same error as
with VACUUM, so i dont think it was a VACUUM issue.
Thanks Gregor for your help!!
Gerardo
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
