I found recently that on one of our systems uses default postgres database as it's... well, database.
I want to move all the data to another db in the same cluster. But the database is relatively large and the system is somewhat 24/7.
Maybe I could simply rename the postgres db? And then create another one named postgres and use it as maintenance db.
This sounds like a not safe thing to do and my intuition says I should stick to traditional dump/restore methods.
Or maybe I'm overreacting?
