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