Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect to postgresql using url

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?

like image 388
Omnipresent Avatar asked Jan 30 '10 15:01

Omnipresent


1 Answers

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

like image 76
Håvard S Avatar answered Oct 05 '22 01:10

Håvard S