I have a problem with my postgresql instance. I don't start service. My server had stopped abrupt because a fs was full . It have a only partition. I think that a postgresql clog file is corrupt.
I used RPMs for install PostgreSQL with default repository postgresql-8.4.13-1.el6_3.i686 postgresql-devel-8.4.13-1.el6_3.i686 postgresql-libs-8.4.13-1.el6_3.i686 postgresql-server-8.4.13-1.el6_3.i686 postgresql-contrib-8.4.13-1.el6_3.i686
My linux distro is CentOS 6.3 # uname -a Linux servername 2.6.32-279.5.2.el6.i686
I don't modify postgresql.conf and pg_hba.conf
I don't launch PostgreSQL service. # service postgresql start Starting postgresql service: [FAILED]
No error in pgstartup.log but i have a fatal error in log ($PG_DATA/log/postgresql-Thu.log) LOG: database system was interrupted; last known up at 2013-08-08 23:50:36 BST LOG: database system was not properly shut down; automatic recovery in progress LOG: record with zero length at 0/1C000174 LOG: redo is not required FATAL: could not access status of transaction 188140 DETAIL: Could not read from file "pg_clog/0000" at offset 40960: Success. LOG: startup process (PID 2284) exited with exit code 1 LOG: aborting startup due to startup process failure
I try to create a new file clog without successfully I try too to use pg_resetxlog without successfully too how do i do for back the last transaction or checkpoint ?