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.
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 |