How to rename postgres database in heroku

Question

I've added heroku postgres addon.

The DATABASE_URL is something like postgres://xxxxxxxxx:[email protected]:5432/ddo2ahvosfggq

I want the database name to be like my_app_database. I want to rename ddo2ahvosfggq to my_app_database.

How can I do that?

Can I use ALTER DATABASE? http://www.postgresql.org/docs/9.1/static/sql-alterdatabase.html

There is already a question in StackOverflow How to rename database in Heroku?

But the answers is to rename the app. I don't know how renaming app will work?

If my_app is the name of my heroku app. Will the below DATABASE_URL work?

postgres://xxxxxxxxx:[email protected]:5432/my_app

This is the syntax to rename the database ALTER DATABASE current_name RENAME TO my_app_database — Sonalkumar sute
– Sonalkumar sute, Commented Jul 22, 2015 at 11:40
Don't understand what is the motive of the custom db name. Just FYI, you can use constant to refer to your database on heroku i.e. DATABASE_URL — RAJ
– RAJ, Commented Jul 22, 2015 at 12:05
@SamuelAlexander Heroku don't use your settings mentioned in database.yml for production. It automatically generate required things. You can remove production section from your database.yml and push to heroku. Still heroku will work fine. — RAJ
– RAJ, Commented Jul 23, 2015 at 5:29

D-side · Accepted Answer · 2015-07-22 12:37:17Z

4

You can't. It's a Database-as-a-Service (DBaaS) and database name is not customizable there. You just get it from the service and use. Since it's not a user-facing detail for web applications, pretty names are of no use. So why bother?

Most actions you can do with your database are listed on Heroku Postgres website. You can:

regenerate credentials (that don't include database name, only username and password)
wipe the database (that doesn't rename the database as well, just drops the tables)
create one more database (but it will be named randomly, just as all the others)

edited Jul 22, 2015 at 12:37

answered Jul 22, 2015 at 12:29

D-side

9,5353 gold badges31 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

max · Accepted Answer · 2015-07-22 12:12:24Z

2

You don't ever really need to type in the name of the production database on Heroku.

Heroku has a post commit hook which writes the production DB details into /config/database.yml.

If you ever really need to to query the database without a model you would establish a connection by:

ActiveRecord::Base.establish_connection
query = ActiveRecord::Base.connection.execute('SELECT * FROM foo;')

answered Jul 22, 2015 at 12:12

max

103k15 gold badges113 silver badges177 bronze badges

Collectives™ on Stack Overflow

How to rename postgres database in heroku

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related