Search Postgresql Archives

Re: Recovering database after disk crash

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

 



After doing some more reading I've come to the conclusion that I'm in
completely over my head.  I got a fresh copy of the corrupt data and
am starting from the very beginning.  Here's the error I get on
startup:

postgres@vsimkus-laptop:/usr/lib/postgresql/8.2/bin$ ./postgres  -D
/var/lib/postgresql/8.2/main
2008-05-12 16:16:02 CDT LOG:  could not load root certificate file
"root.crt": no SSL error reported
2008-05-12 16:16:02 CDT DETAIL:  Will not verify client certificates.
2008-05-12 16:16:02 CDT LOG:  database system was interrupted at
2008-04-16 09:28:36 CDT
2008-05-12 16:16:02 CDT LOG:  unexpected pageaddr 0/1114A000 in log
file 0, segment 17, offset 14295040
2008-05-12 16:16:02 CDT LOG:  invalid primary checkpoint record
2008-05-12 16:16:02 CDT LOG:  unexpected pageaddr 0/1114A000 in log
file 0, segment 17, offset 14295040
2008-05-12 16:16:02 CDT LOG:  invalid secondary checkpoint record
2008-05-12 16:16:02 CDT PANIC:  could not locate a valid checkpoint record
2008-05-12 16:16:02 CDT LOG:  startup process (PID 8359) was
terminated by signal 6
2008-05-12 16:16:02 CDT LOG:  aborting startup due to startup process failure

pg_control output:

 ./pg_controldata /var/lib/postgresql/8.2/main
pg_control version number:            822
Catalog version number:               200611241
Database system identifier:           5126483664462806975
Database cluster state:               in production
pg_control last modified:             Wed 16 Apr 2008 09:28:36 AM CDT
Current log file ID:                  0
Next log file segment:                18
Latest checkpoint location:           0/11DA3C38
Prior checkpoint location:            0/11DA3BF0
Latest checkpoint's REDO location:    0/11DA3C38
Latest checkpoint's UNDO location:    0/0
Latest checkpoint's TimeLineID:       1
Latest checkpoint's NextXID:          0/908105
Latest checkpoint's NextOID:          2001259
Latest checkpoint's NextMultiXactId:  7
Latest checkpoint's NextMultiOffset:  13
Time of latest checkpoint:            Wed 16 Apr 2008 09:13:56 AM CDT
Minimum recovery ending location:     0/0
Maximum data alignment:               4
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
Date/time type storage:               64-bit integers
Maximum length of locale name:        128
LC_COLLATE:                           en_US.UTF-8
LC_CTYPE:                             en_US.UTF-8

I ran pg_resetxlog in my previous mucking around, but that's when all
hell broke loose, so I'm holding off until someone more qualified
advises me to do so.

TIA

Vic


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux