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.laggner@ti.bund.de
Homepage: http://www.ti.bund.de
