How to set up Postgresql locally on ubuntu to deploy on Heroku?

Question

PostgreSQL

How to set username and password for database? Where to store them in a Rails application in databases.yml or in environment variables? In the documentation https://devcenter.heroku.com/articles/heroku-postg... the entire installation of postgresql boils down to
$sudo apt-get install postgresql
$which psql
$psql Trying psql
myself
: FATAL: role "vagrant" does not exist
[email protected]:/vagrant/sands$

Answer 1

I solved the problem by reinstalling postgresql using tutorials.jumpstartlab.com/topics/vagrant_setup.html and advice toster.ru/answer?answer_id=281953 by @Whats .