Can I rename my database?

Postgres and MySQL do not currently support an operation to rename your database. To rename your database, you must dump and then reload your database under the new name. If you want to change a database name using the dump/reload process, contact Engine Yard Support because we need to coordinate with our developers to update the records on the backend.

Note: The Engine Yard platform does not follow the Rails standard database naming conventions because Engine Yard Cloud offers you the ability to clone an environment using EBS snapshots. This capability makes it easier for you to refresh staging environments or build out temporary development/testing environments quickly. When the production database has a name of _production, any environment cloned from this would also have that same name. These duplicate names resulted in a lot of confusion.


Article is closed for comments.