Updated on 2024-10-14 GMT+08:00

Loading a Driver

  • Before using the driver, perform the following operations:
    1. Decompress the driver package of the corresponding version and copy psycopg2 to the site-packages folder in the Python installation directory as the root user.
      tar zxvf xxxx-Python.tar.gz
      su root
      cp psycopg2 $(python3 -c 'import site; print(site.getsitepackages()[0])') -r
    2. Change the psycopg2 directory permission to 755.
      chmod 755 $(python3 -c 'import site; print(site.getsitepackages()[0])')/psycopg2 -R
    3. Add the psycopg2 directory to the environment variable $PYTHONPATH and validate it.
      export PYTHONPATH=$(python3 -c 'import site; print(site.getsitepackages()[0])'):$PYTHONPATH
    4. For non-database users, configure the lib directory in LD_LIBRARY_PATH after decompression.
      export LD_LIBRARY_PATH=path/to/lib:$LD_LIBRARY_PATH
  • Load the database driver before creating a database connection.
    import  psycopg2