If you are on RHEL, would using the dnf module be better?
I suggest this, after reading stackoverflow
This isn’t just CentOS, I think. psycopg has native dependencies, so to build from source (which is what pip does), the PostgreSQL development libraries need to be there. (The C headers, maybe? I don’t know much about compiling native code.)