On Fri, Jun 02, 2006 at 01:11:27PM +0530, Gourish Singbal wrote:
> This Error came since the 0002 file from the pg_clog folder was missing.
> Since the logs are missing from pg_clog folder can perfom pg_resetxlogs to
> reset the logs and bring up the database.
Understand that this will almost cert
Joao,
If you had send the Email to pgsql-admin mailing list you would have got a faster answer to ur query..
here is what i managed to do:-
1. I deleted the
$ls -lart the pg_clog folder
total 756-rw--- 1 postgres users 262144 2006-04-10 17:16 0001-rw--- 1 postgres users 262144 20
when i try do \d in psql on a table i get this
message!
this happens too when i try to run pg_dump...
ERROR: could not access status of transaction
4294967295DETAIL: could not open file "pg_clog/0FFF": File or
directory not found
someone could help me?? PleasE!