By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,809 Members | 1,999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,809 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
table.

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
Reuben
Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.