I am new to sails and its connection to database. I plan to use Heroku to host my app so I would like to use Postgresql.
I have changed config.datastore file with the following code:
default: { adapter: 'sails-postgresql', url: 'postgresql://postgres:postgres@localhost:5432/postgres', max: 1 }
On Sails documentation it sais that url is url: 'postgresql://user:password@host:port/database'
, but I dont understand where should I get user and password from. Do I need to initiate the postgresql and set it up and define a new database?
I am just trying to understand the mechanics behind this setup.