title: Kong won't connect to PostgreSQL
body: <p>I'm not using Docker.</p>
  
  <p>I've installed PostgreSQL 11 and created a user <code>kong</code> that owns a database <code>kong</code>.   On the same linux box I've installed Kong, and am trying to get it to connect to the DB using <a href="https://docs.konghq.com/install/redhat/?_ga=2.40810210.1574540670.1566848424-998489320.1566848424" rel="nofollow noreferrer">these instructions</a>.</p>
  
  <p>Here's a snippet from kong.conf:</p>
  
  <pre><code>database = postgres
  pg_host = 127.0.0.1
  pg_port = 5432
  pg_timeout = 5000
  pg_user = kong
  pg_password = Passw0rd!
  pg_database = kong
  </code></pre>
  
  <p>Also, per <a href="https://www.cyberciti.biz/faq/psql-fatal-ident-authentication-failed-for-user/" rel="nofollow noreferrer">this</a>, I've modified pg_hba.conf to include:</p>
  
  <pre><code># TYPE  DATABASE        USER            ADDRESS                 METHOD
  local   all             all                                     trust
  host    all             all             127.0.0.1/32            trust
  </code></pre>
  
  <p>Still, when I do:</p>
  
  <pre><code>kong migrations bootstrap -c /etc/kong/kong.conf
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>Error: [PostgreSQL error] failed to retrieve server_version_num: FATAL: Ident authentication failed for user "kong"
  </code></pre>
  
  <p>I've made sure PostgreSQL has the same password for <code>kong</code> that is in the kong.conf.</p>
  
  <p>What am I missing?</p>