You're only allowing "trust" authentication, not "ident" authentication.
On 3/26/20 2:29 PM, Ted To wrote:
>
> 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
>
--
Angular momentum makes the world go 'round.