Switch test requirements from psycopg2-binary package to pscyopg2

[Jon Dufresne]

The psycopg2 project recommends not using the psycopg2-binary package. Here are the relevant warnings:

​http://initd.org/psycopg/docs/install.html#binary-install-from-pypi

Note: The psycopg2-binary package is meant for beginners to start playing with Python and PostgreSQL without the need to meet the build requirements.

If you are the maintainer of a publish 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.

Note: The binary packages come with their own versions of a few C libraries, among which libpq and libssl, which will be used regardless of other libraries available on the client: upgrading the system libraries will not upgrade the libraries used by psycopg2. Please build psycopg2 from source if you want to maintain binary upgradeability.

Warning: The psycopg2 wheel package comes packaged, among the others, with its own libssl binary. This may create conflicts with other extension modules binding with libssl as well, for instance with the Python ssl module: in some cases, under concurrency, the interaction between the two libraries may result in a segfault. In case of doubts you are advised to use a package built from source.

We should follow the advice and use the pscyopg2 package and used stop using the binary package.

[Jon Dufresne]

​PR

[Carlton Gibson <carlton.gibson@…>]

In 8076ae68:

Fixed #30483 -- Switched test requirement to psycopg2 package.