How to connect to postgresql using url

heroku, postgresql, ruby-on-rails, taps

Solution

Try `heroku db:push postgres://username:password@localhost/myrailsdb`.

Problem

I had asked an earlier question which did not get any replies. Basically I get an error `invalid database url` when I try to do `heroku db:push`. I figured I can try explicitly providing the database url. I tried: `heroku db:push postgres://postgres@localhost/myrailsdb` But that gave error: ``` Failed to connect to database: Sequel::DatabaseConnectionError -> PGError fe_sendauth: no password supplied ``` What is the format for providing username and password?

Original source

Related problems