0

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?

asked Dec 25, 2024 at 7:41

1 Answer 1

2

It is just fine to rename the postgres database and create a new one. The database will have a non-standard object ID, but that shouldn't matter at all.

answered Dec 25, 2024 at 19:59

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.