From: olologin <olologin@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Problem with pg_hba.conf
Date: Fri, 20 Nov 2015 14:44:45 +0300
Message-ID: <564F07AD.3010302@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello folks, i have some weird problem which i cannot solve. I'm trying
to setup PostgreSQL for first time (I've never used it before, and maybe
this question is too newbie, but still):
> root@usersE420:/var/lib/postgresql/9.4/main# sudo -u postgres psql -qt
> postgres=# \l
> overseer | overseer | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> ..........
>
> postgres=# \du
> overseer | | {}
> postgres | Superuser, Create role, Create DB, Replication | {}
>
> postgres=# show hba_file;
> /etc/postgresql/9.4/main/pg_hba.conf
What pg_hba.conf contains (last lines):
> # Database administrative login by Unix domain socket
> local all postgres peer
>
> # TYPE DATABASE USER ADDRESS METHOD
>
> # "local" is for Unix domain socket connections only
> local all all md5
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
> # IPv6 local connections:
> #host all all ::1/128 md5
> # Allow replication connections from localhost, by a user with the
> # replication privilege.
> #local replication postgres peer
> #host replication postgres 127.0.0.1/32 md5
> #host replication postgres ::1/128 md5
After editing of this file i restarted server with:
> root@usersE420:/var/lib/postgresql/9.4/main# /etc/init.d/postgresql
> restart
> [ ok ] Restarting postgresql (via systemctl): postgresql.service.
But still i cannot login into psql with overseer account:
> root@usersE420:/var/lib/postgresql/9.4/main# psql -qt -U overseer
> psql: FATAL: Peer authentication failed for user "overseer"
> root@usersE420:/var/lib/postgresql/9.4/main# psql -qt -U overseer -W
> Password for user overseer:
> psql: FATAL: Peer authentication failed for user "overseer"
I'm also confused because i think that it's still tries to use peer
authentication.
Help with this pls, Ubuntu 15.10, PostgreSQL 9.4
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: olologin@gmail.com
Subject: Re: Problem with pg_hba.conf
In-Reply-To: <564F07AD.3010302@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox