(psycopg2.OperationalError) SCRAM authentication requires libpq version 10 or above (python:3.7-slim)

[jose-leal-casique]

Good morning, currently we use the python:3.7-slim with an architecture of amr64, we use libpq-dev, in the container it has version 13.5-0+deb11u1 but when using it with python I used version 90624 of libpq-dev, already We try to update it by downloading and installing the binary package to modify the version but it does not update the version used in python.

python console in docker container

version installed libpq-dev in container

for your time, thank you

[tianon]

I think you'll need to install the newer libpq-dev before you pip install psycopg2. If you want to control the version, I'd also suggest getting more specific than python:3.7-slim such as python:3.7-slim-bullseye, which also will make it more obvious which variant of https://www.postgresql.org/download/linux/debian/ to include if you want to choose a very specific version of PostgreSQL / libpq.

In the future, these sorts of questions/requests would be more appropriately posted to a dedicated support forum, such as the Docker Community Forums, the Docker Community Slack, or Stack Overflow.