Unable to deploy sqitch database (--username requires a value!)

[younanjo]

Having followed the steps in repo readme, when trying to deploy the sqitch database i get:

> cd rpg-boilerplate/db && sqitch deploy
Adding registry tables to db:pg://postgres:@localhost:8001/localdb
2018-02-26 03:42:47.209 GMT [57365] FATAL:  --username requires a value
"/usr/local/bin/postgres" unexpectedly returned exit value 1

What am i missing?

[chadfurman]

Hi! Try running from the db folder instead, as that is where sqitch.conf is
https://github.com/chadfurman/rpg-boilerplate/blob/master/db/sqitch.conf

[chadfurman]

Oh, I see you are already running in the db folder.

If your sqitch.conf looks like the one I posted, then something else is wrong... the database should have been created with a postgres user that has password localdev

Also, the URI for postgres you posted is missing the password, but that might be a secuiryt thing (do not show the pass etc) -- make sure your URI is right. Can you try connecting manually?
Connection information: postgres:localdev@localhost:8001
https://github.com/chadfurman/rpg-boilerplate/blob/master/example_docker-compose.yml#L63

What version of sqitch are you running?