可能重复: 如何清空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)... donedb: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)... doneThe 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?
发布评论