Database corruption

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

 



Due to Hard disk space issue on the WAL partition, database was down , When I
am going to start postgres  again ,got following error message

This DB is grater than 1 TB  restore will take long time , any other way
other than pg_resetxlog ?


Nov 14 04:32:41 dbname postgres[4384]: [2-1] 2011-11-14 04:32:41.423 EST
4384 LOG:  invalid record length at 500C/5EFFF2B8
Nov 14 04:32:41 dbname postgres[4384]: [3-1] 2011-11-14 04:32:41.423 EST
4384 LOG:  invalid primary checkpoint record
Nov 14 04:32:41 dbname postgres[4384]: [4-1] 2011-11-14 04:32:41.423 EST
4384 LOG:  invalid resource manager ID in secondary checkpoint record
Nov 14 04:32:41 dbname postgres[4384]: [5-1] 2011-11-14 04:32:41.423 EST
4384 PANIC:  could not locate a valid checkpoint record
Nov 14 04:32:41 dbname postgres[4383]: [1-1] 2011-11-14 04:32:41.424 EST
4383 LOG:  startup process (PID 4384) was terminated by signal 6: Aborted
Nov 14 04:32:41 dbname postgres[4383]: [2-1] 2011-11-14 04:32:41.424 EST
4383 LOG:  aborting startup due to startup process failure




pg_controldata : Result is


pg_control version number:            843
Catalog version number:               200904091
Database system identifier:           5404099570172901375
Database cluster state:               in production
pg_control last modified:             Mon 14 Nov 2011 01:02:51 AM EST
Latest checkpoint location:           500C/5EFFF2B8
Prior checkpoint location:            500C/5EFFF270
Latest checkpoint's REDO location:    500C/5EFFF2B8
Latest checkpoint's TimeLineID:       10000
Latest checkpoint's NextXID:          1/2784291602
Latest checkpoint's NextOID:          63034795
Latest checkpoint's NextMultiXactId:  1658683101
Latest checkpoint's NextMultiOffset:  3632122117
Time of latest checkpoint:            Mon 14 Nov 2011 01:02:51 AM EST
Minimum recovery ending location:     0/0
Maximum data alignment:               8
Database block size:                  8192
Blocks per segment of large relation: 131072
WAL block size:                       8192
Bytes per WAL segment:                16777216
Maximum length of identifiers:        64
Maximum columns in an index:          32
Maximum size of a TOAST chunk:        1996
Date/time type storage:               64-bit integers
Float4 argument passing:              by value
Float8 argument passing:              by value



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Database-corruption-tp4990279p4990279.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[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