Reed Kempf <rkempf(at)gmail(dot)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
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Bill Dika||Date: 2005-11-12 18:58:14|
|Subject: Application using PostgreSQL as a back end (experienced programmers please)|
|Previous:||From: Reed Kempf||Date: 2005-11-12 16:48:07|
|Subject: postgresql database password|