I am running into the same issue when I build a docker container.

The timescale-vector package explicitly depends on psycopg2 (the non-binary version). This adheres to the advice provided by psycopg2:

If you are the maintainer of a published package depending on psycopg2 you shouldn’t use psycopg2-binary as a module dependency. For production use you are advised to use the source distribution.

Building psycopg from source requires a few prerequisites to be installed. Make sure these are installed before trying to pip install timescale-vector

@ShukriChiu I believe you may need to add libpq-dev to packages.txt at the root of your streamlit app.

@mcr-kaes Similarly try running apt install libpq-dev

Add this information to the README