Hi,
This question may not be relevant for this forum but as my only use of Potgresql relates to an implementation of the Calendar Server I thought I'd start here.
I've been running Calendar Server for me and my wife on a mac mini and we share several calendars on our iphones using the mac mini as the server. Recently, the mac mini started to behave strangely in all sorts of ways and despite not wanting to, I had to resort to a reformat of the hard drive, restoring the whole machine from a time machine backup. However, since the restore, the Calendar Server no longer starts up and I get the following in my log file:
31/07/2011 23:41:18 ReportCrash[327] Saved crash report for postgres[325] version ??? (???) to /Users/administrator/Library/Logs/DiagnosticReports/postgres_2011-07-31-234118_MyMachineName.crash
The text of the crash report is as follows:
Process: postgres [325]
Path: /Users/administrator/calendar/postgresql-9.0.3/_root/bin/postgres
Identifier: postgres
Version: ??? (???)
Code Type: X86-64 (Native)
Parent Process: postgres [324]
Date/Time: 2011-07-31 23:41:16.743 +0100
OS Version: Mac OS X 10.6.8 (10K540)
Report Version: 6
Exception Type: EXC_CRASH (SIGABRT)
Exception Codes: 0x0000000000000000, 0x0000000000000000
Crashed Thread: 0 Dispatch queue: com.apple.main-thread
Application Specific Information:
abort() called
Thread 0 Crashed: Dispatch queue: com.apple.main-thread
0 libSystem.B.dylib 0x00007fff897840b6 __kill + 10
1 libSystem.B.dylib 0x00007fff898249f6 abort + 83
2 postgres 0x000000010028327e errfinish + 574
3 postgres 0x0000000100041b5c StartupXLOG + 10556
4 postgres 0x00000001000422f2 StartupProcessMain + 242
5 postgres 0x0000000100059389 AuxiliaryProcessMain + 1465
6 postgres 0x0000000100192ab1 StartChildProcess + 241
7 postgres 0x000000010019527d PostmasterMain + 2605
8 postgres 0x0000000100137b15 main + 933
9 postgres 0x00000001000008d4 start + 52
Thread 0 crashed with X86 Thread State (64-bit):
rax: 0x0000000000000000 rbx: 0x0000000000000000 rcx: 0x00007fff5fbfdc38 rdx: 0x0000000000000000
rdi: 0x0000000000000145 rsi: 0x0000000000000006 rbp: 0x00007fff5fbfdc50 rsp: 0x00007fff5fbfdc38
r8: 0x00000001002f2eae r9: 0x0000000000000000 r10: 0x00007fff897800fa r11: 0x0000000000000206
r12: 0x00000001004b9300 r13: 0x0000000100461d48 r14: 0x0000000000000016 r15: 0x0000000100600960
rip: 0x00007fff897840b6 rfl: 0x0000000000000206 cr2: 0x00007fff8980f162
Binary Images:
0x100000000 - 0x10043efff +postgres ??? (???) <47C8BA95-4A12-313B-F5FA-E39F9421BB7F> /Users/administrator/calendar/postgresql-9.0.3/_root/bin/postgres
0x7fff5fc00000 - 0x7fff5fc3bdef dyld 132.1 (???) <B536F2F1-9DF1-3B6C-1C2C-9075EA219A06> /usr/lib/dyld
0x7fff807f7000 - 0x7fff807fbff7 libmathCommon.A.dylib 315.0.0 (compatibility 1.0.0) <95718673-FEEE-B6ED-B127-BCDBDB60D4E5> /usr/lib/system/libmathCommon.A.dylib
0x7fff89735000 - 0x7fff898f6fef libSystem.B.dylib 125.2.11 (compatibility 1.0.0) <9AB4F1D1-89DC-0E8A-DC8E-A4FE4D69DB69> /usr/lib/libSystem.B.dylib
0x7fffffe00000 - 0x7fffffe01fff libSystem.B.dylib ??? (???) <9AB4F1D1-89DC-0E8A-DC8E-A4FE4D69DB69> /usr/lib/libSystem.B.dylib
I'm also getting the following in my postgres log file:
FATAL: the database system is starting up
LOG: unexpected pageaddr 0/2058000 in log file 0, segment 4, offset 360448
LOG: invalid primary checkpoint record
LOG: unexpected pageaddr 0/2056000 in log file 0, segment 4, offset 352256
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
FATAL: the database system is starting up
LOG: startup process (PID 325) was terminated by signal 6: Abort trap
LOG: aborting startup due to startup process failure
(Just to be clear, the extracts form the logs may not be form the same attempts to start things up - just in case anyone was looking at PIDs not being the same, etc.)
Things I've tried so far are to re-compile and re-install my version of postgres and to use pg_resetxlog, just with the 'f' switch, both to no avail.
Is it dead? Can I save it? If so how? What else can I try? My concern lies mainly around how to salvage the current data that is on our phones that hasn't been synched with the server - I can use iCal to export a backup of the calendars and restore them on a new installation but it's the data on the phones that gives me cause for concern. If I can get things back up and running again, that would be great!!
Hope you can help.
Many thanks,
Matt