Affordable Database Approach for Staging

[lillian]

you will always be able to run the “legacy” unmanaged postgres:

Managed Postgres pricing

you can still run the unmanaged postgres for the same price, we’re not stopping you from doing that. for now the flyctl commands still exist, but in a future where they will be removed you can look at this repository that has the configuration GitHub - fly-apps/postgres-flex: Postgres HA setup using repmgr or you can of course deploy postgres yourself without any of this; for a cheap (but not reliable) single-machine instance it should be quite simple.

if you are using MPG for production, you can also create a new user/db inside your production cluster for development so you don’t need to pay more: https://fly.io/docs/mpg/configuration/#creating-additional-users