title: how to upgrade libpq in CentOS 7.8
body: <p>I am using a python app, but it get error:</p>
  <pre><code>Call stack:
    File &quot;/usr/lib64/python3.6/threading.py&quot;, line 884, in _bootstrap
      self._bootstrap_inner()
    File &quot;/usr/lib64/python3.6/threading.py&quot;, line 916, in _bootstrap_inner
      self.run()
    File &quot;/usr/lib64/python3.6/threading.py&quot;, line 864, in run
      self._target(*self._args, **self._kwargs)
    File &quot;/usr/lib64/python3.6/concurrent/futures/thread.py&quot;, line 69, in _worker
      work_item.run()
    File &quot;/usr/lib64/python3.6/concurrent/futures/thread.py&quot;, line 56, in run
      result = self.fn(*self.args, **self.kwargs)
    File &quot;/usr/local/lib64/python3.6/site-packages/apscheduler/executors/base.py&quot;, line 125, in run_job
      retval = job.func(*job.args, **job.kwargs)
    File &quot;/root/pydolphin/dolphin/biz/RssEntry.py&quot;, line 18, in rss_sub
      sources = rss.select()
    File &quot;/root/pydolphin/dolphin/common/db/RssSource.py&quot;, line 41, in select
      logger.error(&quot;query rss source error&quot;, e)
  Message: 'query rss source error'
  Arguments: (OperationalError('(psycopg2.OperationalError) SCRAM authentication requires libpq version 10 or above\n',),)
  </code></pre>
  <p>and I check the libpq version:</p>
  <pre><code>➜  pydolphin git:(master) ✗ yum install postgresql-devel
  Failed to set locale, defaulting to C
  Loaded plugins: fastestmirror, langpacks
  Loading mirror speeds from cached hostfile
  Package postgresql-devel-9.2.24-4.el7_8.x86_64 already installed and latest version
  Nothing to do
  </code></pre>
  <p>what should I do to upgrade the libpq? Now I am tried this:</p>
  <pre><code>wget -c http://mirrors.zju.edu.cn/postgresql/latest/postgresql-13.1.tar.gz
  cd ./postgresql-13.1
  ./configure --prefix=/opt/pg13
  make 
  make install
  </code></pre>
  <p>problem still not solved.</p>