title: valentina db doesn't allow me to use ssh into a postgres even though i can do it normally
body: <p>I have a AWS server which I can access using SSH with a .pem key.</p>
  
  <p>Using valentina, i tried to access the postgres this way</p>
  
  <p><a href="https://i.stack.imgur.com/8zDFp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8zDFp.png" alt="enter image description here"></a></p>
  
  <p>I keep getting a failed Ident message.</p>
  
  <p>I used that same .pem file and ssh into the server.
  Used the same postgres user and password to access using psql client.</p>
  
  <p>It works.</p>
  
  <p>What do I need to do to make the Valentina Studio work as well?</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>I have changed my <code>pg_hba.conf</code> to the following:</p>
  
  <pre><code>host    all             all             *                       ident
  # "local" is for Unix domain socket connections only
  local   all             all                                     md5
  # IPv4 local connections:
  host    all             all             127.0.0.1/32            ident
  # IPv6 local connections:
  host    all             all             ::1/128                 ident
  </code></pre>
  
  <p>I can run <code>psql -U postgres</code> on the postgres server.</p>
  
  <p>I cannot run <code>psql -h localhost -U postgres</code> on the the postgres server.</p>
  
  <p><strong>UPDATE 2:</strong></p>
  
  <pre><code># "local" is for Unix domain socket connections only
  local   all             postgres                                peer
  local   all             all                                     peer
  # IPv4 local connections:
  host    all             all             127.0.0.1/32            md5
  # IPv6 local connections:
  host    all             all             ::1/128                 md5
  </code></pre>
  
  <p>This solves the issue</p>