is there really no option to rename an existing database? Is there something like DB aliases that I overlooked?
Our use case is to do an atomic switch of DBs, e.g., do some sort of ETL into a ‘staging’ instance and then, if everything went fine, switch this DB to become the ‘live’ instance (which typically already exists, i.e., should be “updated”) - atomic and fast. Any alternative suggestions to achieve this?
I think the only way to rename a database is to copy and then drop the old database but that requires that the database is offline and will take some time. I think the best thing to do might be to simply put the database behind a proxy and just update the proxy.