Migrate from psycopg2 to psycopg(3) for postgres

[logan-hcg]

While not pressing (as psycopg2 continues to be supported), I think most new effort is behind the psycopg3 implementation: https://www.psycopg.org/install/

[AliRaza5959]

yes, it would help move towards the binary rather than build from source for psycopg2.