Lucas Brasilino <brasilino(at)recife(dot)pe(dot)gov(dot)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