Database corruption

From: Manoj K P <manoj(at)comodo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database corruption
Date: 2011-11-14 09:54:52
Message-ID: 1321264492950-4990279.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Rob Audenaerde 2011-11-14 16:53:06 migrating statistics without data?
Previous Message Andy Colson 2011-11-14 01:22:31 Re: Restore db