So we have three development environments from a programming point of view. Each environment has its own postgres database.
Let's say a table gets an extra column in our development environment, we need to update the acceptance environment as well when the code is merged back. Other changes can be column renames etc.
This is needed because we are still developing the app quite heavily, but it is still important that the production environment can keep up on a database level as well.
So the question is: how can I propagate schema updates to a different database without loss of data.