Destroying a Postgres DB on Heroku

Question

I want to destroy the database but I'm not sure what the command would be. Does anyone know how to do this?

possible duplicate of How to empty DB in heroku

Erwin Brandstetter
– Erwin Brandstetter

2012-06-09 01:44:05 +00:00
Commented Jun 9, 2012 at 1:44 — Erwin Brandstetter
– Erwin Brandstetter, Commented Jun 9, 2012 at 1:44

Beau · Accepted Answer · 2013-08-02 23:13:53Z

140

You shouldn't use a postgres command to fully delete your database, as you will not have permissions to create a new one. Instead you should use the heroku command to clear out your database:

heroku pg:reset DATABASE_URL

edited Aug 2, 2013 at 23:13

Beau

11.5k8 gold badges47 silver badges38 bronze badges

answered Oct 2, 2011 at 16:53

CraigKerstiens

5,9891 gold badge27 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

siamii Over a year ago

What is DATABASE? I can't find the url. Im heroku there is only database name and host, user, pass. What is the database?

Neara Over a year ago

@siamii did it just now, the full command is heroku pg: reset DATABASE_URL, DATABASE_URL is an environ config and points to your db url, heroku knows how to read it, so just type it in exactly like that and it works.

ahnbizcad Over a year ago

If you already did do it the wrong way and lost permission to create a new database, how do you fix that?

Yuri Gadow Over a year ago

A fine comment to protect folks from making a mistake, but not an answer to the question at all.

Stephane Paquet Over a year ago

I would also recommend reading stackoverflow.com/questions/6906715/… heroku pg:reset DATABASE --confirm {app-name} is also a good command to use

JacobEvelyn · Accepted Answer · 2015-09-24 17:23:18Z

35

None of the answers above actually describe how to destroy a Heroku database, which was the original question (and what led me here seeking an answer).

From their docs, either of these will work:

heroku addons:destroy heroku-postgresql:tier (where tier is the database tier, like hobby-dev)
heroku addons:destroy HEROKU_POSTGRESQL_<COLOR> (if you have more than one database of that tier)

Note that because this is a destructive action it will prompt you to confirm the action. If you want to use this in a script you can skip the prompt with something like this:

heroku addons:destroy HEROKU_POSTGRESQL_<COLOR> --confirm <appname>

Hope that's helpful!

edited Sep 24, 2015 at 17:23

answered Feb 19, 2015 at 16:29

JacobEvelyn

3,9911 gold badge45 silver badges56 bronze badges

2 Comments

JacobEvelyn Over a year ago

Thanks @john-paul-ashenfelter for the edit suggestion. Not sure why your suggestions were rejected but I've made the changes you suggested.

UsamaMan Over a year ago

To create the database again, heroku addons:create heroku-postgresql:tier (where tier is the database tier, like hobby-dev). Have a look at the reference

Jordan Townsend · Accepted Answer · 2013-04-02 17:36:16Z

9

To answer Siamii's question above: DATABASE in heroku pg:reset DATABASE is by default postgres

answered Apr 2, 2013 at 17:36

Jordan Townsend

1011 silver badge3 bronze badges

Comments

Andy · Accepted Answer · 2015-11-11 02:08:30Z

7

Simply follow the steps below. Run

heroku pg:reset DATABASE

to recreate the database with nothing in it, then run

heroku run rake db:migrate

to initialize the database with the correct schema & data.

Look at the new heroku documentation it helps ;)

edited Nov 11, 2015 at 2:08

Andy

5,4542 gold badges45 silver badges46 bronze badges

answered Nov 11, 2014 at 21:25

TheRealRonDez

2,8072 gold badges32 silver badges40 bronze badges

Collectives™ on Stack Overflow

Destroying a Postgres DB on Heroku

4 Answers 4

5 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related