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.

[SQL] alter user does not changes password

2002-10-01 Thread Lucas Brasilino
Hi all: I know it's a silly question, but I've googling around and searching mailist archive with no answer to my question: I'm using self compiled PostgreSQL 7.2.1 in a RH 7.1 box. As described in http://www.postgresql.org/idocs/index.php?sql-alteruser.html I'm trying to change