Postgres Pro
Downloads
Home   >   mailing lists

Re: alter user does not changes password - Mailing list pgsql-sql

From Tom Lane
Subject Re: alter user does not changes password
Date
Msg-id 24874.1033483921@sss.pgh.pa.us
Whole thread Raw
In response to alter user does not changes password  (Lucas Brasilino <brasilino@recife.pe.gov.br>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: dima
Date:
Subject: Re: alter user does not changes password
Next
From: Roland Roberts
Date:
Subject: Re: [GENERAL] arrays