|
Не запускается служба PostgreeSQL | ☑ | ||
---|---|---|---|---|
0
Novicadmin
27.04.16
✎
10:49
|
Переделал инфу
2016-04-27 13:28:46 IRKT LOG: database system was interrupted; last known up at 2016-04-27 13:16:51 IRKT 2016-04-27 13:28:46 IRKT LOG: invalid primary checkpoint record 2016-04-27 13:28:46 IRKT LOG: invalid secondary checkpoint link in control file 2016-04-27 13:28:46 IRKT PANIC: could not locate a valid checkpoint record 2016-04-27 13:28:46 IRKT LOG: startup process (PID 8912) exited with exit code 3 2016-04-27 13:28:46 IRKT LOG: aborting startup due to startup process failure Из поисков в интернете попробовал выполнить pg_controldata PostgreSQL\9.4.2-1.1C\bin>pg_controldata e:\pql pg_control version number: 942 Catalog version number: 201409291 Database system identifier: 6254454928233336196 Database cluster state: in production pg_control last modified: 27.04.2016 9:04:41 Latest checkpoint location: DC/223641B8 Prior checkpoint location: DC/1F301DA8 Latest checkpoint's REDO location: DC/213D1950 Latest checkpoint's REDO WAL file: 00000001000000DC00000021 Latest checkpoint's TimeLineID: 1 Latest checkpoint's PrevTimeLineID: 1 Latest checkpoint's full_page_writes: on Latest checkpoint's NextXID: 0/2148384 Latest checkpoint's NextOID: 4123902 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Latest checkpoint's oldestXID: 668 Latest checkpoint's oldestXID's DB: 1 Latest checkpoint's oldestActiveXID: 0 Latest checkpoint's oldestMultiXid: 1 Latest checkpoint's oldestMulti's DB: 16402 Time of latest checkpoint: 27.04.2016 9:04:31 Fake LSN counter for unlogged rels: 0/1 Minimum recovery ending location: 0/0 Min recovery ending loc's timeline: 0 Backup start location: 0/0 Backup end location: 0/0 End-of-backup record required: no Current wal_level setting: minimal Current wal_log_hints setting: off Current max_connections setting: 200 Current max_worker_processes setting: 8 Current max_prepared_xacts setting: 0 Current max_locks_per_xact setting: 64 Maximum data alignment: 8 Database block size: 8192 Blocks per segment of large relation: 131072 WAL block size: 8192 Bytes per WAL segment: 16777216 Maximum length of identifiers: 64 Maximum columns in an index: 32 Maximum size of a TOAST chunk: 1996 Size of a large-object chunk: 2048 Date/time type storage: 64-bit integers Float4 argument passing: by value Float8 argument passing: by reference Data page checksum version: 0 Далее пробую почистить логи PostgreSQL\9.4.2-1.1C\bin>pg_resetxlog -o 4123902 -x 2148384 -f e:\pql pg_resetxlog: could not create pg_control file: File exists Как устранить проблему с pg_resetxlog: could not create pg_control file: File exists? |
|||
1
mehfk
27.04.16
✎
10:52
|
Удалить существующий файл?
|
|||
2
mgk2
27.04.16
✎
10:54
|
(0) Что значит "Переделал инфу"?
|
|||
3
Novicadmin
27.04.16
✎
10:56
|
(2) закрыли преыдущую тему а с этим же сообщением не давал создать тему, пожтому добавил строчку
|
|||
4
Novicadmin
27.04.16
✎
10:56
|
(1) Какой существующий?
|
|||
5
Gary417
27.04.16
✎
10:59
|
(4) как вы думает что означает заклинание "File exists" ?
|
|||
6
Novicadmin
27.04.16
✎
11:01
|
(5) файл существует!?
|
|||
7
Novicadmin
27.04.16
✎
11:01
|
т.е. удалить файл pg_control?
|
|||
8
Gary417
27.04.16
✎
11:02
|
(7) ну если совсем страшно, можно забекапить
|
|||
9
Novicadmin
27.04.16
✎
11:08
|
после удаления файла то что делать?
|
|||
10
Novicadmin
27.04.16
✎
11:23
|
После всех монипуляций получается завести службу постгри но пападаю на PANIC: could not open critical system index 2662
|
|||
11
ansh15
27.04.16
✎
11:58
|
(10) http://postgresql.nabble.com/Server-continuously-enters-to-recovery-mode-td5802321.html
Последний пост. И на всякий случай - (8) Можно развернуть PostgrеSQL на другом компе, скопировать туда папку data и экспериментировать... |
|||
12
Novicadmin
27.04.16
✎
13:22
|
c:\Program Files\PostgreSQL\9.4.2-1.1C\bin>postgres --single -D E:\PQL postgres
2016-04-27 17:44:22 IRKT PANIC: could not open critical system index 2671 |
|||
13
Novicadmin
27.04.16
✎
13:22
|
c:\Program Files\PostgreSQL\9.4.2-1.1C\bin>reindexdb --system postgres
reindexdb: could not connect to database postgres: PANIC: could not open critical system index 2671 |
|||
14
ansh15
27.04.16
✎
15:50
|
http://www.postgresql.org/docs/9.5/static/sql-reindex.html
Раздел Notes, в конце. "Things are more difficult if you need to recover from corruption of an index on a system table. In this case it's important for the system to not have used any of the suspect indexes itself. (Indeed, in this sort of scenario you might find that server processes are crashing immediately at start-up, due to reliance on the corrupted indexes.) To recover safely, the server must be started with the -P option, which prevents it from using indexes for system catalog lookups. One way to do this is to shut down the server and start a single-user PostgreSQL server with the -P option included on its command line. Then, REINDEX DATABASE, REINDEX SYSTEM, REINDEX TABLE, or REINDEX INDEX can be issued, depending on how much you want to reconstruct. If in doubt, use REINDEX SYSTEM to select reconstruction of all system indexes in the database. Then quit the single-user server session and restart the regular server. See the postgres reference page for more information about how to interact with the single-user server interface." "-P Ignore system indexes when reading system tables, but still update the indexes when modifying the tables. This is useful when recovering from damaged system indexes" |
Форум | Правила | Описание | Объявления | Секции | Поиск | Книга знаний | Вики-миста |