Re: Simple commands don't work - Mailing list pgsql-novice

Larry Martell wrote:
>> Check in your pg_hba.conf file.
>> http://www.postgresql.org/docs/9.1/interactive/auth-pg-hba-conf.html
>>
>> If you are working on the server itself, pg_hba.conf may be letting you in
>> without passwords.  You'll see a line like 'host all all 127.0.0.1 trust'.
> 
> Nope - all the host entries have password.

Then there is probably a line that reads
  local   all    all    trust

If you connect without specifying a host (locally via socket), this will
let you in without a password.

Yours,
Laurenz Albe