The leader db in my postgres cluster is stuck on an older version than the replica dbs.
Instances
ID PROCESS VERSION REGION DESIRED STATUS HEALTH CHECKS RESTARTS CREATED
c70****** app 16 ⇡ lax run running (replica) 3 total, 2 passing, 1 critical 0 42m17s ago
********* app 16 ⇡ ewr run running (replica) 3 total, 2 passing, 1 critical 0 42m17s ago
********* app 14 dfw run running (replica) 3 total, 2 passing, 1 critical 0 1h5m ago
********* app 14 mia run running (failed to co) 3 total, 1 passing, 2 critical 0 1h5m ago
I am not sure what to do. I have tried restarting the db and scaling it. No effect.
This happened when I scaled from 8GB RAM to 32GB RAM and back to 8 after a couple of minutes. After about 30 minutes of waiting for DB to pick itself up, I switched to 32GB RAM. After 10 more minutes, I switched to 31.
I think switching this has caused my problem. Maybe I just have to wait now.
Log from the stuck VM:
2022-12-17T22:44:50Z app[*****] mia [info]exporter | ERRO[1117] Error opening connection to database (postgresql://flypgadmin:PASSWORD_REMOVED@[IP_REMOVED]:PORT_REMOVE/postgres?sslmode=disable): dial tcp [****: connect: connection refused source="postgres_exporter.go:1658"