| From: | Larry Martell <larry(dot)martell(at)gmail(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| Cc: | Jason Whitener <jwhitene(at)pcc(dot)edu>, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Simple commands don't work |
| Date: | 2014-06-17 14:45:27 |
| Message-ID: | CACwCsY55s=JJMHj5OSD2tOqSu=7haU3MGPhGykQbt1NNdgaxiw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, Jun 17, 2014 at 3:23 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2014-06-17 15:34:39 | Re: Simple commands don't work |
| Previous Message | Albe Laurenz | 2014-06-17 07:23:13 | Re: Simple commands don't work |