470,641 Members | 1,125 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

FATAL 2: open of /var/lib/postgres/data/pg_clog/0004 failed: No such file or directory

My database appears to be a little corrupted, so far it's running along 99%
ok, but i am getting some strange results. Primarily i can't back it up
because of the following error. Similar errors occur when I try to drop a

boo:/var/backups# su postgres pg_dump rj > /var/backups/rj.dump
pg_dump: FATAL 2: open of /var/lib/postgres/data/pg_clog/0004 failed: No
such file or directory
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "product" failed:
PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY "product"
TO stdout;
I am also getting a strange problem where some queries don't return any
data, real simple ones like this doesn't work
select * from atable WHERE id=4000
but the following will find that row (among others)
select * from atable WHERE id>3900 AND id < 4100

very strange.... i think it's corrupted indexes or the like.

Version PostgreSQL 7.2.1
Please help
Nov 11 '05 #1
0 1526

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by bettina | last post: by
2 posts views Thread by Edwin Pauli | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.