how to connect to postgresql using url

Question

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

So I figured I can try explicitly providing the database url.

so 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

So what is the format for providing username and password?

Answer 1

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