title: Python psycopg2 SCRAM authentication
body: <p>I'm trying to run a python application that uses psycopg2-binary==2.9.1, but I'm hitting this  error:</p>
  <pre><code>psycopg2.OperationalError: SCRAM authentication requires libpq version 10 or above
  </code></pre>
  <p>When I check the version of libpq installed, it suggests I have 12.8:</p>
  <pre><code>sudo dpkg -l | grep libpq
  ii  libpq5:arm64                       12.8-0ubuntu0.20.04.1             arm64        PostgreSQL C client library
  </code></pre>
  <p>I searched around and saw some recommendations to switch off scram authentication, so I changed authentication to md5 in pg_hba.conf and postgresql.conf and then reloaded config (and restarted my database).</p>
  <p>I'm still getting this problem. Does anyone know what is wrong ? Thanks in advance</p>