FAQ

Brian Hurt wrote:
Hello all-

I'm getting an error on a Postgres database when I access a table:
template0=# select * from pg_language;
ERROR: could not access status of transaction 575
DETAIL: could not open file "pg_clog/0000": No such file or directory
template0=#
More information: I did (as postgres):

dd bs=49152 count=1 if=/dev/zero of=/database/postgres/pg_clog/0000

to create the clog file (49152 is the size of
/database/postgres/pg_clog/0001), then fixed the permissions (chmod 0600
/database/postgres/pg_clog/0000). This seems to have fixed the problem.

The partition is on a Areca raid control, and some playing with the
areca cli didn't turn up any HD errors. We're running bonnie++ on the
partition to see if it detects any errors.

Brian

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJun 17, '08 at 4:11p
activeJun 21, '08 at 6:52p
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Brian Hurt: 2 posts Tom Lane: 1 post

People

Translate

site design / logo © 2021 Grokbase