I'm not using Docker.
I've installed PostgreSQL 11 and created a user kong
that owns a database kong
. On the same linux box I've installed Kong, and am trying to get it to connect to the DB using these instructions.
Here's a snippet from kong.conf:
database = postgres
pg_host = 127.0.0.1
pg_port = 5432
pg_timeout = 5000
pg_user = kong
pg_password = Passw0rd!
pg_database = kong
Also, per this, I've modified pg_hba.conf to include:
# TYPE DATABASE USER ADDRESS METHOD
local all all trust
host all all 127.0.0.1/32 trust
Still, when I do:
kong migrations bootstrap -c /etc/kong/kong.conf
I get:
Error: [PostgreSQL error] failed to retrieve server_version_num: FATAL: Ident authentication failed for user "kong"
I've made sure PostgreSQL has the same password for kong
that is in the kong.conf.
What am I missing?
md5
. Same result. So I've changed back totrust
which tells it to not even require a password.trust
method is ignored. Some classic reasons: 1) forgetting to reload the postgres service. 2) editing the wrong file 3) having rules above in the file taking precedence (the first match wins)