Dotaz: psql: error: FATAL: the database system is in recovery mode

[zipi]

Zdravím,

poničil se filesystem pomocí recovery jsem vytáhl celou složku pro DB. Narazil jsem na problém, že DB nejsem schopen spustit končím chybou: psql: error: FATAL: the database system is in recovery mode. Nedokázal by někdo poradit .?

2022-08-23 18:31:59.013 CEST [2918190] LOG:  autovacuum launcher process (PID 2918917) exited with exit code 1
2022-08-23 18:31:59.013 CEST [2918190] LOG:  terminating any other active server processes
2022-08-23 18:31:59.013 CEST [2918190] LOG:  background worker "logical replication launcher" (PID 2918919) exited with exit code 1
2022-08-23 18:31:59.014 CEST [2918190] LOG:  all server processes terminated; reinitializing
2022-08-23 18:31:59.076 CEST [2918920] LOG:  database system was interrupted; last known up at 2022-08-23 18:31:59 CEST
2022-08-23 18:31:59.080 CEST [2918920] LOG:  database system was not properly shut down; automatic recovery in progress
2022-08-23 18:31:59.080 CEST [2918920] LOG:  invalid record length at 58/F1ED698: wanted 24, got 0
2022-08-23 18:31:59.080 CEST [2918920] LOG:  redo is not required
2022-08-23 18:31:59.092 CEST [2918190] LOG:  database system is ready to accept connections
2022-08-23 18:31:59.092 CEST [2918924] FATAL:  could not find relation mapping for relation "pg_database", OID 1262
2022-08-23 18:31:59.093 CEST [2918926] ERROR:  could not find relation mapping for relation "pg_database", OID 1262

Odpovědi

[X]

Mas zalohu?

[zipi]

Dle všeho záloha není ..

[X]

Rekl bych, ze si celou slozku nevytahl. Ta chyba je tady a vaze se na ukladani "vstahu" jako struktura v souborovem systemu viz zde.