Re: [PERFORM] help me problems with pg_clog file

2006-06-05 Thread Jim C. Nasby
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

Re: [PERFORM] help me problems with pg_clog file

2006-06-02 Thread Gourish Singbal
  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

[PERFORM] help me problems with pg_clog file

2006-06-01 Thread Joao
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!