Switch psycopg to binary version

[browniebroke]

We just received a PR to update psycopg to the latest version and it fails the build: #6143:

Using CPython 3.13.7 interpreter at: /opt/hostedtoolcache/Python/3.13.7/x64/bin/python3.13
  × No solution found when resolving dependencies:
  ╰─▶ Because there is no version of psycopg-c{implementation_name
      != 'pypy'}==3.2.12 and psycopg[c]==3.2.12 depends on
      psycopg-c{implementation_name != 'pypy'}==3.2.12, we can conclude that
      psycopg[c]==3.2.12 cannot be used.
      And because your project depends on psycopg[c]==3.2.12, we can conclude
      that your project's requirements are unsatisfiable.

I went looking up the psycopg issue tracker to see whether this was a problem on their end and stumbled upon this issue:

• Docs clarification about psycopg[c] psycopg/psycopg#1195

From reading it, it seems like we could switch from the C variant to the binary without much/any performance penalty. This would simplify and speed up the build. I think this was perhaps more required in the psycopg2 world, but this seems less needed with v3.

Thoughts?

[browniebroke]

FWIW, the build failure from #6143 has gone away after retrying CI so that might just be due to the PR being opened before all packages were published to PyPI.

The question remains though, feels like psycopg[binary] would simplify our setup and build.