cannot start 9.3 after system crash
От | Andreas Laggner |
---|---|
Тема | cannot start 9.3 after system crash |
Дата | |
Msg-id | 54C779AD.5090608@ti.bund.de обсуждение исходный текст |
Ответы |
Re: cannot start 9.3 after system crash
|
Список | 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.laggner@ti.bund.de Homepage: http://www.ti.bund.de
В списке pgsql-general по дате отправления: