title: Postgresql - ERROR: could not access file "$libdir/plpython2": No such file or directory
body: <p>When I run </p>
  
  <pre><code>CREATE EXTENSION plpythonu;
  </code></pre>
  
  <p>on my Postgresql, I get</p>
  
  <pre><code>ERROR:  could not access file "$libdir/plpython2": No such file or directory
  </code></pre>
  
  <p>I installed Python 2.7.16 - <a href="https://www.python.org/ftp/python/2.7.16/python-2.7.16.amd64.msi" rel="nofollow noreferrer">https://www.python.org/ftp/python/2.7.16/python-2.7.16.amd64.msi</a>
  Then <a href="https://get.enterprisedb.com/postgresql/postgresql-11.2-1-windows-x64.exe" rel="nofollow noreferrer">https://get.enterprisedb.com/postgresql/postgresql-11.2-1-windows-x64.exe</a></p>
  
  <p>If I search for plpython2 on entire disk, it isn't found. But I have also python 3 and plpython3 is found. I tried to reinstalled both postgresql installation and python but no luck.</p>
  
  <p>I searched for this error but no solution worked.
  (If I run create language plpython2u; I get the same error.)</p>
  
  <p>I also tried to run </p>
  
  <pre><code>create language plpython3u;
  </code></pre>
  
  <p>to see if that would work but i need to use python2. This one fails on</p>
  
  <pre><code>ERROR:  could not load library "C:/Program Files/PostgreSQL/11/lib/plpython3.dll": The specified module could not be found.
  
  SQL state: XX000
  </code></pre>
  
  <p>but the file exists and postgresql definitely has full access to the file.</p>
  
  <p>Any ideas, hints how I can make python 2 running on postgresql on Windows 10?</p>
  
  <p>Many thanks</p>