Hi there,
I woke up today with a failure check and noticed the DB machine is not working.
It is in suspended state and it fails to start.
I’ve noticed that it is still in PG 14. And as I am trying to find what is happening I’ve noticed the legacy flyio/postgres.
Is this current setup PG 14 and flyio/postgres not supported anymore?
I am trying to find out how I can recover the app before starting on the upgrade work.
Hi… flyio/postgres is indeed officially deprecated now, as are all other self-managed Postgres images—along with all of the flyctl postgres commands:
Unmanaged Fly Postgres is deprecated in favor of ‘fly mpg’ (Managed Postgres). Please visit https://fly.io/docs/mpg/overview/ for more information about Managed Postgres.
This hasn’t fallen off a cliff yet, but you can generally expect a less and less smooth ride with Legacy Postgres as time goes on.
(I don’t speak for Fly.io in any way, though.)
There are some tips and caveats in this earlier thread, which might serve as a reference point…