On Sun, Dec 20, 2015 at 11:47 PM, Emma Saurus <emmasaurus@westnet.com.au> wrote:
> This is a simpler example of another method I have tried which
> does not work for me
>
> postgres-# CREATE USER EmmaChwan WITH ENCRYPTED PASSWORD 'password';
> CREATE ROLE
That created a user named "emmachwan" with that password.
> psql: FATAL: password authentication failed for user "EmmaChwan"
This is an attempt to log in as a completely different user: "EmmaChwan".
See the previous responses.
Kevin Grittner