如何rake db:drop和rake db:create on Heroku? [英] How to rake db:drop and rake db:create on Heroku?
问题描述
可能重复:
如何清空heroku中的数据库
Heroku上的Postgres数据库。它是一个免费的测试版。在本地,当测试时,我经常运行rake db:drop&& rake db:create&& rake db:migrate作为重置数据库的方式。
但是,当我尝试在Heroku上运行时,会出现错误:
无法删除mydatabaseid:#< PG :: Error:FATAL:数据库postgres被拒绝
详细信息:用户没有CONNECT权限。
嗯,好吧,我该怎么完全重置我的数据库,迁移和一切? p>
pg:reset
命令将为您重新创建数据库。用法示例:
$ heroku config | grep POSTGRESQL
HEROKU_POSTGRESQL_RED_URL:postgres:// somedatabaseurl
$ heroku pg:reset HEROKU_POSTGRESQL_RED_URL
!警告:破坏性操作
!这个命令将影响应用程序:myappname
!要继续,请键入myappname或重新运行此命令与--confirm
> myappname
重设HEROKU_POSTGRESQL_RED_URL(DATABASE_URL)... done
db:reset
命令将尝试删除数据库,这不是Heroku的权限允许的。
Possible Duplicate:
How to empty DB in heroku
I have a Postgres database on Heroku. It is one of the free beta ones. Locally, when testing, I often run rake db:drop && rake db:create && rake db:migrate as a way to reset the database.
However, when I try to run this on Heroku, I get the error:
Couldn't drop mydatabaseid : #<PG::Error: FATAL: permission denied for database "postgres"
DETAIL: User does not have CONNECT privilege.
Uh, ok, so how am I supposed to completely reset my database, migrations and everything?
The pg:reset
command will recreate the database for you. Example usage:
$ heroku config | grep POSTGRESQL
HEROKU_POSTGRESQL_RED_URL: postgres://somedatabaseurl
$ heroku pg:reset HEROKU_POSTGRESQL_RED_URL
! WARNING: Destructive Action
! This command will affect the app: myappname
! To proceed, type "myappname" or re-run this command with --confirm
> myappname
Resetting HEROKU_POSTGRESQL_RED_URL (DATABASE_URL)... done
The db:reset
command would try to drop the database, which is not something that Heroku's permissions allow.
这篇关于如何rake db:drop和rake db:create on Heroku?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!