"Christian Meunier" <jelan@magelo.com> writes:
> Is there a way to clean up those commit log ?, i tried to remove 0002 but it
> didnt help( it was then doing error on 0002 too)
You did *what*?
You may as well have done "rm -rf $PGDATA". You're hosed.
I would have liked to look into why it was still trying to reference the
0000 segment after removing it; that suggests a logic problem somewhere.
But with the database now completely nonfunctional due to loss of the
active clog segment, there's probably no way to learn anything useful.
Don't remove files when you don't know what they are.
regards, tom lane