如何将数据库附加到Heroku中的应用程序？

我们在那里做的是分配您的数据库到应用程序中的 DATABASE_URL 环境变量。这是默认情况下将数据库置备到应用程序本地时使用的变量，因此从理论上讲，分配此值应该适合您。

I'm using Heroku's Postgres addon, and I created a new production database from the Heroku Postgres addon page. I Didn't add it directly to my App using the Resources page of my App.

Now I want to attach this database to my App so it'll be recognized by the heroku pg command.

I'm able to use the database btw after setting the DATABASE_URL config var of my app to point to it, but heroku pg command doesn't recognize it yet.

Additional info: The previous database was Shared, and the new one is a Production.

Did you add the database using the app-independent postgres.heroku/ site? Or did you just create a postgresql database in your Heroku control panel?

If you created your database on postgres.heroku/, you will not see the database via your heroku pg:info command. What you can do to add your database to your application, however, would be to:

What we did there was assign your database to the DATABASE_URL environment variable in your application. This is the variable that's used by default when you provision databases locally to your application, so theoretically, assigning this value should work just fine for you.