Reed Kempf <rkempf@gmail.com> writes:
> I read that the -W prompts for a password. I give the password test which I
> set up when I created the user test and it let me in. The problem is I also
> run the same command line login and didn't specify a password.
> Am I missing something with authentication, perhaps a config file setting.
Yup. Password authentication is not the default, you need to adjust
pg_hba.conf if you want to use it. See "Client Authentication" in the
manual.
regards, tom lane