use-postgresql-with-django-flask doesn't ask for password

[ewilson]

sudo -u postgres createuser -s $USER

# Create a new user 
$ sudo -u postgres createuser -s $USER 
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n

This isn't what happened for me. On Ubuntu 14.04, it didn't ask any questions, just created a user. How do I set the password?

Same here, on OS X. I found this documentation createuser. It seems like with 9.4 we have to tell it to be interactive and that we want to set a password.

Additionally, if we use the Postgres.app it automatically creates a user based of off $USER however it does so in a passwordless manner, and I don't know how to access the URI in Flask then.

To continue, with Postgres.app creating a default User there is no postgres user to create a new user from. Not sure about the other methods for installation through OS X.

@ewilson If you haven't gotten this working yet createuser -W will prompt you for a password. Make sure the W is capitalized.