psql: SSL SYSCALL error at docker image

[cutecutecat]

The error is psql: SSL SYSCALL error: Success

This happens when we use psql or psycopg->libpq5 to connect to a encrypted sslmode=require PostgreSQL 16 endpoint, for PGVecto.rs.

pgvector is not tested, but it might have the same error, as this is the issue of PostgreSQL and libpq5.

https://github.com/zilliztech/VectorDBBench/blob/c45876cef17dee92b3f4d1711b4130aa6ecabe39/Dockerfile#L1

OS	version	link	Status
buster[picked]	11.22	https://packages.debian.org/buster/libpq5	Error
bullseye	13.15	https://packages.debian.org/bullseye/libpq5	Error
bookworm	15.7	https://packages.debian.org/bookworm/libpq5	Success

After my tests on local machine:

• psql 11 and 13 have the same error
• psql 14, 15, 16 are ok

So it might be helpful if the Dockerfile could be upgraded to:

FROM python:3.11-bookworm as builder-image

FROM python:3.11-slim-bookworm