Search Postgresql Archives

Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi there,

I had a problem with disconnecting USB disc with PG database on my OPi3.

PG is 11.

Now base refuses to start, with problem reported in log (see attached file).

But I don't have replication configured!

Is it possible to repair this?


Laurent


2022-04-05 20:53:38.892 CEST [12022-04-06 08:30:33.359 CEST [11834] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2022-04-06 08:30:33.360 CEST [11834] LOG:  listening on IPv6 address "::", port 5432
2022-04-06 08:30:33.406 CEST [11834] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-04-06 08:30:33.586 CEST [11835] LOG:  database system was interrupted; last known up at 2022-04-05 20:55:49 CEST
2022-04-06 08:30:34.369 CEST [11835] PANIC:  replication checkpoint has wrong magic 1346542039 instead of 307747550
2022-04-06 08:30:34.371 CEST [11834] LOG:  startup process (PID 11835) was terminated by signal 6: Aborted
2022-04-06 08:30:34.371 CEST [11834] LOG:  aborting startup due to startup process failure
2022-04-06 08:30:34.374 CEST [11834] LOG:  database system is shut down
2022-04-06 08:32:26.775 CEST [11873] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2022-04-06 08:32:26.776 CEST [11873] LOG:  listening on IPv6 address "::", port 5432
2022-04-06 08:32:26.811 CEST [11873] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-04-06 08:32:26.980 CEST [11874] LOG:  database system was interrupted; last known up at 2022-04-05 20:55:49 CEST
2022-04-06 08:32:27.668 CEST [11874] PANIC:  replication checkpoint has wrong magic 1346542039 instead of 307747550
2022-04-06 08:32:27.669 CEST [11873] LOG:  startup process (PID 11874) was terminated by signal 6: Aborted
2022-04-06 08:32:27.670 CEST [11873] LOG:  aborting startup due to startup process failure
2022-04-06 08:32:27.673 CEST [11873] LOG:  database system is shut down

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux