Home > mailing lists

PQencryptPasswordConn called using PostgreSQL9.6. - Mailing list pgsql-novice

From	Valentin Czisch
Subject	PQencryptPasswordConn called using PostgreSQL9.6.
Date	April 6, 2020 14:38:39
Msg-id	CAML35+5jZ-YF8C5txHYbL3NL02OiPj7=yqR5ZjGDwaSm4F-PhQ@mail.gmail.com Whole thread Raw
List	pgsql-novice

Hi!

Since PQencryptPasswordConn was added in PostgreSQL10, the following confuses me:

I am using an Azure Database Server with PostgreSQL9.6.16 on Ubuntu.

During the build of my web app, when the import of the Database is done, I get an ImportError.

File "/home/site/wwwroot/antenv/lib/python3.7/site-packages/django/db/backends/postgresql/base.py"

import psycopg2 as Database

File "/home/site/wwwroot/antenv/lib/python3.7/site-packages/psycopg2/__init__.py"

from psycopg2._psycopg import ( # noqa

ImportError: /home/site/wwwroot/venv/lib/python3.7/site-packages/psycopg2/_psycopg.cpython-37m-x86_64-linux-gnu.so: undefined symbol: PQencryptPasswordConn

Why would the PQencryptPasswordConn-function be missing in PostgreSQL9.6?

Is my installation of psycopg2 flawed? If so, why and how would I fix this?

Hope this is the right place to ask... Thank you for any advice!

Vale.

From: "David G. Johnston"
Date: 06 April 2020, 05:30:35
Subject: Re: Tracking mutations in table data

From: Mark Kelly
Date: 06 April 2020, 20:49:03
Subject: Re: Tracking mutations in table data