我使用Heroku的Postgres插件,并从Heroku Postgres插件页面创建了一个新的生产数据库。 我没有将它直接添加到我的应用程序使用我的应用程序的资源页面。
现在我想将此数据库附加到我的应用程序,会被 heroku pg 命令所识别。
我可以在设置 DATABASE_URL 配置我的应用程序的var指向它,但 heroku pg 命令不能识别它。
其他信息:以前的数据库是共享的,而新的是一个生产。
解决方案是否使用独立于应用程序的 postgres.heroku/ 网站?或者您是在Heroku控制面板中创建postgresql数据库?
rel =noreferrer> postgres.heroku/ ,您将 通过您的看到数据库> heroku pg:info 命令。然而,您可以将数据库添加到您的应用程序中:我们在那里做的是分配您的数据库到应用程序中的 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.
更多推荐
如何将数据库附加到Heroku中的应用程序?
发布评论