From: | Andreas Laggner <andreas(dot)laggner(at)ti(dot)bund(dot)de> |
---|---|
To: | PostgreSQL Mailingliste <pgsql-general(at)postgresql(dot)org> |
Subject: | cannot start 9.3 after system crash |
Date: | 2015-01-27 11:42:37 |
Message-ID: | 54C779AD.5090608@ti.bund.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi list,
the system HDD of a server running postgresql 9.3 died (sudden
electronical death) during a pg_dump. The database is located on a
hardware raid system (another HDD). I installed a new ubuntu 14.04 with
postgresql 9.3 postgis 2.1. But i cannot start the server. First i got
the error:
2015-01-27 09:37:11 CET LOG: database system was shut down at
2015-01-23 16:37:02 CET
2015-01-27 09:37:11 CET LOG: invalid primary checkpoint record
2015-01-27 09:37:11 CET LOG: invalid secondary checkpoint record
2015-01-27 09:37:11 CET PANIC: could not locate a valid checkpoint record
2015-01-27 09:37:11 CET LOG: startup process (PID 5309) was
terminated by signal 6: Aborted
2015-01-27 09:37:11 CET LOG: aborting startup due to startup process
failure
I solved this by executing pg_resetxlog.
Now i get another error and i do not know what else i can do:
2015-01-27 12:02:22 CET LOG: database system was interrupted; last
known up at 2015-01-27 10:24:56 CET
2015-01-27 12:02:22 CET LOG: database system was not properly shut
down; automatic recovery in progress
2015-01-27 12:02:22 CET LOG: record with zero length at 360/E20001C8
2015-01-27 12:02:22 CET LOG: redo is not required
2015-01-27 12:02:22 CET [unknown] [unknown] LOG: incomplete startup packet
2015-01-27 12:02:22 CET FATAL: could not access status of transaction
214707
2015-01-27 12:02:22 CET DETAIL: Could not open file "pg_clog/0000":
Datei oder Verzeichnis nicht gefunden.
2015-01-27 12:02:22 CET LOG: startup process (PID 6520) exited with
exit code 1
2015-01-27 12:02:22 CET LOG: aborting startup due to startup process
failure
thanks for helping - Andreas
--
Dipl. Geoökologe Andreas Laggner
Thünen-Institut für Agrarklimaschutz (AK)
Arbeitsgruppe Emissionsinventare
Johann Heinrich von Thünen-Institut (vTI),
Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei
Thünen Institute of Climate-Smart Agriculture
Johann Heinrich von Thünen Institute (vTI),
Federal Research Institute for Rural Areas, Forestry and Fisheries
Bundesallee 50
D-38116 Braunschweig
Tel.: (+49) (0)531 596 2636
Fax : (+49) (0)531 596 2645
E-mail: andreas(dot)laggner(at)ti(dot)bund(dot)de
Homepage: http://www.ti.bund.de
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2015-01-27 13:18:09 | Re: |
Previous Message | Oliver Dizon | 2015-01-27 10:46:13 |