dbTalk Databases Forums  

Still more pg_clog errors

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Still more pg_clog errors in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve Wolfe
 
Posts: n/a

Default Still more pg_clog errors - 10-13-2004 , 12:01 PM







In reference to the pg_clog errors I'm having, I am still looking for
tips or help. Here's the info again:

"ERROR: could not access status of transaction 143934068
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0089": No
such file or directory

Now, despite creating an 8k file of zeros (or a 256k file of zeros to
match the others in the directory), when I start the database and try a
vacuum, I get the same message, and upon inspection, the file is gone -
as if Postgres is removing the file.

Any tips or help on what I can do?

steve


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.