I am trying to use PostgREST and sqitch on Debian (Wheezy) to provide a REST API for an Android app which queries a Postgres DB, like in this example.
I've written SQL to create the tables, however when I issue the sqitch deploy command (as in the example, with everything working until that point), I get an error:
fe_sendauth: no password supplied
There is neither a password in the example or in the accepted parameters of the sqitch deploy command. When I search on the error I find a SO solution suggesting to try pg_ctl reload, however that doesn't work in this case.
The problem persists regardless of if I am logged in as postgres, root, or some other privileged user.
You probably want to put your password in to a ~/.pgpass file. But there are other ways to go about it, too. See sqitch-authentication for the various ways to supply passwords to Sqitch.