Rails - Oct 2012 - heroku rake db:drop error PG::Error: FATAL: permission denied for database "postgres"

How to empty DB in
heroku<http://stackoverflow.com/questions/4820549/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:\[code\]Couldn''t
drop mydatabaseid : 
#<PG::Error: FATAL: permission denied for database "postgres"
DETAIL: User
does not have CONNECT privilege.
\[/code\]Uh, ok, so how am I supposed to completely reset my database, 
migrations and everything?


-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/GJv6jRxQna8J.
For more options, visit https://groups.google.com/groups/opt_out.

On 5 October 2012 21:41, mukul saharia
<mukul85in-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> 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:\[code\]Couldn''t
> drop mydatabaseid :
> #<PG::Error: FATAL: permission denied for database "postgres"
DETAIL: User
> does not have CONNECT privilege.
> \[/code\]Uh, ok, so how am I supposed to completely reset my database,
> migrations and everything?
Googe found this as the second hit
http://stackoverflow.com/questions/8162420/running-rake-dbdrop-dbcreate-dbmigrate-on-heroku-cedar-stack

I don''t know what pg:reset does on heroku so this may not be relevant
but generally it is better to use rake:schema:load rather than create
followed by running all the migrations.


Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

Please follow:

http://stackoverflow.com/questions/4820549/how-to-empty-db-in-heroku

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/5f7dcd761946eac4c0988e40c52705bd%40ruby-forum.com.
For more options, visit https://groups.google.com/groups/opt_out.