Re: [SQL] alter user does not changes password

2002-10-01 Thread Tom Lane
Lucas Brasilino <[EMAIL PROTECTED]> writes: > but when I try to connect: > $ psql -U camara dbcamara; > User "camara" logs with no password Did you adjust pg_hba.conf to require password authentication? If so, did you SIGHUP the postmaster after changing the file? reg

Re: [SQL] alter user does not changes password

2002-10-01 Thread dima
> alter user camara with password 'canabis!'; > > but when I try to connect: > > $ psql -U camara dbcamara; > > User "camara" logs with no password If I use -W option of psql > It prompts for password and I can enter whatever I want... it accepts! > > It must be a feature.. not a bug.