Re: Simple commands don't work

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Larry Martell *EXTERN*" <larry(dot)martell(at)gmail(dot)com>, Jason Whitener <jwhitene(at)pcc(dot)edu>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Simple commands don't work
Date: 2014-06-17 07:23:13
Message-ID: A737B7A37273E048B164557ADEF4A58B17D0CEFA@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Larry Martell 2014-06-17 14:45:27 Re: Simple commands don't work
Previous Message Ziggy Skalski 2014-06-16 23:52:36 Re: Simple commands don't work