Cluster maintenance, start/stop a database #2038
Unanswered
sumukharaj
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
What is the ideal procedure to stop/start a postgres db cluster operated by zalando.
I try the following procedure and every time after restart, the database does not come up and continues to be in recovery mode.
To stop the cluster
k edit postgresql -n str-development-test-restore-4 ai-postgres
wait for the pod to be terminated
To start the cluster
But many times above procedure takes the cluster to recovery state.
2022-09-12 10:54:06,196 INFO: Lock owner: None; I am ai-postgres-0 2022-09-12 10:54:06,196 INFO: not healthy enough for leader race 2022-09-12 10:54:06,260 INFO: restarting after failure in progress /var/run/postgresql:5432 - no response /var/run/postgresql:5432 - no response 2022-09-12 10:54:08,722 WARNING: Postgresql is not running. 2022-09-12 10:54:08,722 INFO: Lock owner: None; I am ai-postgres-0 2022-09-12 10:54:08,737 INFO: pg_controldata: pg_control version number: 1100 Catalog version number: 201809051 Database system identifier: 6925770682722574383 Database cluster state: shut down in recovery pg_control last modified: Mon Sep 12 10:02:24 2022 Latest checkpoint location: DC0F/31755350 Latest checkpoint's REDO location: DC0F/31755350 Latest checkpoint's REDO WAL file: 000000020000DC0F00000031 Latest checkpoint's TimeLineID: 2 Latest checkpoint's PrevTimeLineID: 2 Latest checkpoint's full_page_writes: on
Any suggestion in this regard will be appreciated.
Beta Was this translation helpful? Give feedback.
All reactions