Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Destroying a Postgres DB on Heroku

Tags:

postgresql

heroku

destroy

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

like image 460
captDaylight Avatar asked Oct 01 '11 20:10

captDaylight

People also ask

How do I delete data from Heroku database?

Your organization can use the “heroku addons:destroy” command to initiate deletion of a primary, forked or follower Heroku Postgres database.

How do I rollback a Heroku database?

You have to run heroku rake db:rollback while the updated code that has the . down migration is deployed to Heroku. After that, you can rollback the code. This was the missing step, there was no migration to rollback to seeing that I rollback the code already, thanks!

Is Heroku Postgres good?

Heroku Postgres offers a number of different plans, each of which provides the highest security standards. Ultimately, Heroku Postgres is a great option for any developer looking to build, scale, or maintain their databases without having to take infrastructure into consideration.

1 Answers

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
like image 55
CraigKerstiens Avatar answered Oct 26 '22 12:10

CraigKerstiens
Sign in to Comment

Related questions

How do I connect to PostgreSQL without specifying a database name?
Postgresql find total disk space used by a database
Checking if a postgresql table exists under python (and probably Psycopg2)
Counting the number of occurrences of a substring within a string in PostgreSQL
PostgreSQL wrong converting from timestamp without time zone to timestamp with time zone
How to handle Ruby on Rails error: "Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'"
Changing a postgres containers server port in Docker Compose
Postgres ERROR: could not open file for reading: Permission denied
Insert if not exists, else return id in postgresql
Case insensitive unique model fields in Django?
GROUP BY and COUNT using ActiveRecord
Get the last N rows in the database in order?
How to create a new database with the hstore extension already installed?
Return pre-UPDATE column values using SQL only
How to get the trigger(s) associated with a view or a table in PostgreSQL
Order varchar string as numeric
About clustered index in postgres
How to insert current_timestamp into Postgres via python
How do I transfer production database to staging on Heroku using pgbackups? Getting error
PL/pgSQL checking if a row exists

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!