Opened 5 years ago

Closed 5 years ago

#30483 closed Cleanup/optimization (fixed)

Switch test requirements from psycopg2-binary package to pscyopg2

Reported by: Jon Dufresne Owned by: nobody
Component: Testing framework Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

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.

Change History (3)

comment:1 by Jon Dufresne, 5 years ago

Has patch: set

comment:2 by Simon Charette, 5 years ago

Triage Stage: UnreviewedAccepted

comment:3 by Carlton Gibson <carlton.gibson@…>, 5 years ago

Resolution: fixed
Status: newclosed

In 8076ae68:

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

Note: See TracTickets for help on using tickets.
Back to Top