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