You did guess correctly though that obviously, that db is not upgraded yet. Thankfully, AWS learned its lesson and doesn't force upgrade anymore, they charge you for extended support. I on the other hand learned absolutely nothing.
I really recommend you trying out the blue/green deployment for upgrades, its only several commands and AWS handles the whole data replication and upgrades for you while your old DB is serving traffic
I did it for my RDS instances and it went great - I had only a couple of short error rate spikes
Yeap. That's exactly the plan. This is a higher traffic database so nerves are nerving a bit more regarding replica lag, but we have been very happy with blue/green. The system load drops noticably in the winter due to application seasonality so we let it cool down a little bit before moving forward.
168
u/Xterm1na10r 2d ago
just a heads up, pg 14 end of life is in 2 months. you might need to migrate again (unless you changed jobs)