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

On Tue, Jun 17, 2014 at 3:23 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> 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.

There are these local entires:

local   all             postgres                                peer
local   all             all                                     peer