pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedalter user does not changes password
3+ messages / 3 participants
[nested] [flat]
* alter user does not changes password
@ 2002-10-01 14:46 Lucas Brasilino <brasilino@recife.pe.gov.br>
2002-10-01 14:49 ` Re: alter user does not changes password dima <_pppp@mail.ru>
2002-10-01 14:52 ` Re: alter user does not changes password Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: Lucas Brasilino @ 2002-10-01 14:46 UTC (permalink / raw)
To: pgsql-sql
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 a user's password as:
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... I know I'm making a mistake.. but..
where??
bests regards
--
[]'s
Lucas Brasilino
brasilino@recife.pe.gov.br
http://www.recife.pe.gov.br
Emprel - Empresa Municipal de Informatica (pt_BR)
Municipal Computing Enterprise (en_US)
Recife - Pernambuco - Brasil
Fone: +55-81-34167078
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: alter user does not changes password
2002-10-01 14:46 alter user does not changes password Lucas Brasilino <brasilino@recife.pe.gov.br>
@ 2002-10-01 14:49 ` dima <_pppp@mail.ru>
1 sibling, 0 replies; 3+ messages in thread
From: dima @ 2002-10-01 14:49 UTC (permalink / raw)
To: Lucas Brasilino <brasilino@recife.pe.gov.br>; +Cc: pgsql-sql
> 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... I know I'm making a mistake..
> but.. where??
can you quote pg_hba.conf (without comments naturally) here?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: alter user does not changes password
2002-10-01 14:46 alter user does not changes password Lucas Brasilino <brasilino@recife.pe.gov.br>
@ 2002-10-01 14:52 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2002-10-01 14:52 UTC (permalink / raw)
To: Lucas Brasilino <brasilino@recife.pe.gov.br>; +Cc: pgsql-sql
Lucas Brasilino <brasilino@recife.pe.gov.br> 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?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-10-01 14:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-01 14:46 alter user does not changes password Lucas Brasilino <brasilino@recife.pe.gov.br>
2002-10-01 14:49 ` dima <_pppp@mail.ru>
2002-10-01 14:52 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox