Menu
This is the command I have to find the name of a heroku database:
$ heroku config | grep POSTGRESQL I get a result similar to:
HEROKU_POSTGRESQL_NAVY_URL: postgres://wxjwilh:[email protected]:52/d14grmkt which part of this output is the database name I can use with the command:
$ heroku pg:reset <DATABASE> I tried using the whole url but got an invalid argument error.
868
You can find the application name on the database page at data.heroku.com. Your database is attached to the Heroku app and is accessible via an app config var containing the database URL, even if you host no code in the application itself.
The DATABASE_URL config var designates the URL of an app's primary Heroku Postgres database. For apps with a single database, its URL is automatically assigned to this config var. For apps with multiple Postgres databases, set the primary database with heroku pg:promote .
hope everyone confuses with placeholder and constant.
Assume having a db with name d6u5qhrlnbdfmp. then it is NOT necessary to type
heroku pg:reset d6u5qhrlnbdfmp Instead we can plainly type
heroku pg:reset DATABASE_URL the sample output
E:\git\stutzen>heroku pg:reset d6u5qhrlnbdfmp --app stutzen ! Unknown database: d6u5qhrlnbdfmp. Valid options are: DATABASE_URL, HEROKU_ POSTGRESQL_CYAN_URL E:\git\stutzen>heroku pg:reset DATABASE_URL --app stutzen ! WARNING: Destructive Action ! This command will affect the app: stutzen ! To proceed, type "stutzen" or re-run this command with --confirm stutzen > stutzen Resetting HEROKU_POSTGRESQL_CYAN_URL (DATABASE_URL)... done 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
