cannot start 9.3 after system crash

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-01-27 13:18:09 Re:
Previous Message Oliver Dizon 2015-01-27 10:46:13