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
Uh oh!
There was an error while loading. Please reload this page.
-
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