From: | Ted To <wintrymix(at)theo(dot)to> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Ident authentication failed |
Date: | 2020-03-26 19:29:33 |
Message-ID: | bbe31397-27f5-d787-7e8b-e333ada38451@theo.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm trying to configure miniflux and am struggling to figure out how to
configure postgres for that purpose. (The miniflux instructions are
very terse.) Regardless of whether I run the command as the postgres
user or the miniflux user, I get similar errors. I am running Centos 7
using the updated scl version of postgres (9.6.10).
With the following, the postgres user "miniflux" along with the password
are specified in /etc/miniflux.conf.
$ miniflux -c /etc/miniflux.conf -migrate
Current schema version: 0
Latest schema version: 26
Migrating to version: 1
[FATAL] [Migrate] pq: Ident authentication failed for user "miniflux"
I have no problems logging into postgres as the miniflux user using the
same password specified in /etc/miniflux.conf.
Running the same command without specifying the configuration file uses
the postgres user and also fails
$ miniflux -migrate
[INFO] The default value for DATABASE_URL is used
Current schema version: 0
Latest schema version: 26
Migrating to version: 1
[FATAL] [Migrate] pq: Ident authentication failed for user "postgres"
My /var/opt/rh/rh-postgresql96/lib/pgsql/data/pg_hba.conf file includes
# TYPE DATABASE USER ADDRESS METHOD
local miniflux miniflux trust
local miniflux postgres trust
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 trust
I'm at a complete loss.
Any suggestions?
Thanks,
Ted To
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2020-03-26 19:35:13 | Re: Ident authentication failed |
Previous Message | Matt Magoffin | 2020-03-26 18:50:01 | Re: Duplicate key violation on upsert |