K
K
kerevra2019-08-04 13:06:50
PostgreSQL
kerevra, 2019-08-04 13:06:50

PostgreSQL won't start after a power failure. How to make it work?

After a power failure, the DBMS does not start.
Help, please, advice. You need to extract the data. Inside 7 user databases, there are backups only from some of them. Now everything works in a test virtual machine, there are file copies of the directory with data at the time of failure.
Building PostgreSQL from PostgresPro for 1C. Launch log in Single-User and software version in the spoiler.

Details
[email protected]:/usr/lib/postgresql/9.6/bin# ./postgres -V
postgres (PostgreSQL) 9.6.1
[email protected]:/usr/lib/postgresql/9.6/bin# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.6 LTS
Release: 16.04
Codename: xenial
[email protected]:/usr/lib/postgresql/9.6/bin# su postgres -c './postgres --single -D /var/lib/postgresql/9.6/main -P -d 1'
2019-08-04 14:00:55 +04 [2381-1] ОТЛАДКА: mmap(153092096) with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory
2019-08-04 14:00:55 +04 [2381-2] ЗАМЕЧАНИЕ: система БД была выключена: 2019-08-04 13:40:31 +04
2019-08-04 14:00:55 +04 [2381-3] ОТЛАДКА: запись о контрольной точке по смещению 1257/77000258
2019-08-04 14:00:55 +04 [2381-4] ОТЛАДКА: redo record is at 1257/77000258; shutdown TRUE
2019-08-04 14:00:55 +04 [2381-5] ОТЛАДКА: next transaction ID: 0:136840678; next OID: 267109380
2019-08-04 14:00:55 +04 [2381-6] ОТЛАДКА: next MultiXactId: 1; next MultiXactOffset: 0
2019-08-04 14:00:55 +04 [2381-7] ОТЛАДКА: oldest unfrozen transaction ID: 583, in database 12442
2019-08-04 14:00:55 +04 [2381-8] ОТЛАДКА: oldest MultiXactId: 1, in database 1
2019-08-04 14:00:55 +04 [2381-9] ОТЛАДКА: commit timestamp Xid oldest/newest: 0/0
2019-08-04 14:00:55 +04 [2381-10] ОТЛАДКА: предел наложения ID транзакций равен 2147484230, источник ограничения - база данных с OID 12442
2019-08-04 14:00:55 +04 [2381-11] ОТЛАДКА: предел наложения MultiXactId равен 2147483648, источник ограничения - база данных с OID 1
2019-08-04 14:00:55 +04 [2381-12] ОТЛАДКА: starting up replication slots
2019-08-04 14:00:55 +04 [2381-13] ОТЛАДКА: предел наложения MultiXactId равен 2147483648, источник ограничения - база данных с OID 1
2019-08-04 14:00:55 +04 [2381-14] ОТЛАДКА: Граница членов мультитранзакции сейчас: 4294914944 (при старейшей мультитранзакции 1)
2019-08-04 14:00:55 +04 [2381-15] ВАЖНО: could not find tuple for opclass 1
2019-08-04 14:00:55 +04 [2381-16] ЗАМЕЧАНИЕ: выключение
2019-08-04 14:00:55 +04 [2381-17] ОТЛАДКА: performing replication slot checkpoint
2019-08-04 14:00:55 +04 [2381-18] ЗАМЕЧАНИЕ: система БД выключена

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question