Menu
How to remove postgres database from heroku, which was created using the dev free plan. https://postgres.heroku.com/databases
I tried using heroku addons:remove --confirm --app salty-river-24 but it says app not found. Is this the correct syntax.
712
If you created the database with the web UI on postgres.heroku.com, you need to navigate to it from https://postgres.heroku.com/databases , then click on the gear icon on the right. There should be a destroy link.
The first method to remove a PostgreSQL database is to use the following SQL statement: DROP DATABASE <database name>; The command removes the directory containing the database information and the catalog entries. Only the database owner can execute the DROP DATABASE command.
Basically - no. postgres database is here as a non-template database with reasonable guarantee that it exists - so any script that doesn't know where to connect to, can connect there. if you will remove template1 - you will lose the ability to create new databases (at least easily).
If you created the database with the web UI on postgres.heroku.com, you need to navigate to it from https://postgres.heroku.com/databases , then click on the gear icon on the right. There should be a destroy link. If you don't see a destroy link, then you probably aren't the owner and lack privileges.
51
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
