pg_clog problems
Hi everyone.
I'm having problems with a database, I get the following errors while accesing it (from my application and from pg_dump)
ERROR: Could not access status of transaction 65536
DETAIL: Could not read from file /usr/share/postgresql/data/pg_clog/0000 at offset 16384: No error.
I'm using postgreSQL 7.4RC2 under cygwin (on winxp). It probably got damagged because of a bad windows shutdown or something.
My question is, is there a way to reinit pg_clog files? I had read somewhere about something called pgsql_fsck or something, would this tool fix the problem? (if yes, please tell me the correct name
)
Thanks in advance.
I'm having problems with a database, I get the following errors while accesing it (from my application and from pg_dump)
ERROR: Could not access status of transaction 65536
DETAIL: Could not read from file /usr/share/postgresql/data/pg_clog/0000 at offset 16384: No error.
I'm using postgreSQL 7.4RC2 under cygwin (on winxp). It probably got damagged because of a bad windows shutdown or something.
My question is, is there a way to reinit pg_clog files? I had read somewhere about something called pgsql_fsck or something, would this tool fix the problem? (if yes, please tell me the correct name
)Thanks in advance.
Вложения
В списке pgsql-general по дате отправления:
Предыдущее
От: Bruno Wolff IIIДата:
Сообщение: Re: Wanted: Trick for granting permissions to users with hyphens