We are planning to use postgresq on production, but there is one question
about how to patch a db. We don't want to overwrite the old version
directly, so that we can rollback if the new version has issues. So we
want to install it a different location such as /home/postgres/14.1 for
version 14.1 (all binary should be under 14.1 or sub-fold of 14.1) and
/home/postgres/14.0 for 14.0, in this way we can easily switch between
different versions. But apt install on ubuntu doesn't have the option for a
customized location. So what's the best practice to patch postgres?