PostgreSQL don't start

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

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 ?
 

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux