I am not sure if I am doing something wrong, but all the postgres commands are failing when I run them against my postgres app.
Commands I tried:
flyctl postgres config view -a <postgres-app-name>
flyctl postgres connect -a <postgres-app-name>
flyctl postgres users list -a <postgres-app-name>
flyctl postgres db list -a <postgres-app-name>
They all return Error command is not compatible with this image. The only pg command that works is flyctl postgres list. Other app commands such as logs, ssh, etc work fine with this app.
flyctl version
fly v0.0.431 darwin/arm64 Commit: eeef66af BuildDate: 2022-11-13T17:11:38Z
Hey, run flyctl image show --app <postgres-app-name> to see which image version you are running and update to the latest with flyctl image update --app <postgres-app-name>.
I only see v0 and v1 deploys and the second might have been a fly deploy from a month ago, but I can’t recall as I was following the docs but might have made a mistake.
Is the only way to revert this is to create a new app and move the data over?
First save your fly.toml file with flyctl config save --app <postgres-app-name>
Then run flyctl deploy --image flyio/postgres:<tag>. The image tag here must match the major version you are already running. That should be 14.4 in your case.
You should have the latest image with all the flyctl goodies after that.
Note: next time you want to update your postgres image, use flyctl image instead of flyctl deploy.
I got the following after running flyctl deploy --image:
2 desired, 1 placed, 0 healthy, 1 unhealthy [restarts: 2]
→ v3 failed - Failed due to unhealthy allocations - not rolling back to stable job version 3 as current job has same specification and deploying as v4