On 6/1/19 8:07 PM, Tom K wrote:
https://www.postgresql.org/docs/10/app-postgres.html
Single-User Mode
...
and see if that at least gets the server started. This is a highly
restricted so do not expect much usability.
These servers did crash before however didn't' notice anything
particularly wrong at the time. Perhaps a better check was in order.
Here is the result from attempting to start the DB in single user mode.
-bash-4.2$ /usr/pgsql-10/bin/postgres --single -D /data/patroni
--config-file=/data/patroni/postgresql.conf
2019-06-01 23:06:28.679 EDT [31969] LOG: database system was
interrupted; last known up at 2019-04-28 06:06:24 EDT
2019-06-01 23:06:28.953 EDT [31969] LOG: invalid record length at
0/4C35CDF8: wanted 24, got 0
2019-06-01 23:06:28.953 EDT [31969] LOG: invalid primary checkpoint record
2019-06-01 23:06:28.953 EDT [31969] LOG: using previous checkpoint
record at 0/4C34EDA8
2019-06-01 23:06:28.953 EDT [31969] PANIC: replication checkpoint has
wrong magic 0 instead of 307747550
That comes from origin.c in the logical replication section of the code.
Did you have logical replication set up?
What was the role of this cluster in the original setup?
Aborted
-bash-4.2$
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
