notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details on branch 2023Q1
py-psycopg2 High performance Python adapter for PostgreSQL
2.9.10 databases on this many watch lists=15 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.9.9_1Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2006-08-10 19:35:33
Last Update: 2024-10-22 21:58:18
Commit Hash: 810ea94
People watching this port, also watch:: libgcrypt, libxml2, libgpg-error, p5-Digest-HMAC, p5-Net-SSLeay
Also Listed In: python
License: LGPL3
WWW:
https://www.psycopg.org/
https://github.com/psycopg/psycopg2
Description:
psycopg2 is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being small, fast and stable. It supports the full Python DBAPI-2.0 and is thread safe. psycopg2 is different from the other database adapter because it was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a conspicuous number of concurrent INSERTs or UPDATEs. Every open Python connection keeps a pool of real (UNIX or TCP/IP) connections to the database. Every time a new cursor is created, a new connection does not need to be opened; instead one of the unused connections from the pool is used. That makes psycopg very fast in typical client-server applications that create a servicing thread every time a client request arrives.
HomepageHomepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}psycopg2>0:databases/py-psycopg2@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-psycopg2/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-psycopg2
  • pkg install py311-psycopg2
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py311-psycopg2 listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-psycopg2
Package flavors (<flavor>: <package>)
  • py311: py311-psycopg2
distinfo:
TIMESTAMP = 1729594454 SHA256 (psycopg2-2.9.10.tar.gz) = 12ec0b40b0273f95296233e8750441339298e6a572f7039da5b260e3c8b60e11 SIZE (psycopg2-2.9.10.tar.gz) = 385672

Packages (timestamps in pop-ups are UTC):
py37-psycopg2
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--2.8.6---2.8.6-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
 
py39-psycopg2
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly--2.9.6--2.9.92.9.92.9.9
FreeBSD:14:latest--2.9.5--2.9.6-2.9.6
FreeBSD:14:quarterly-----2.9.92.9.92.9.9
FreeBSD:15:latest--n/a-n/a2.9.92.9.92.9.9
 
py311-psycopg2
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.9.102.9.10-2.9.102.9.10---
FreeBSD:13:quarterly2.9.9_12.9.9_1-2.9.9_12.9.9_1---
FreeBSD:14:latest2.9.102.9.10-2.9.102.9.10---
FreeBSD:14:quarterly2.9.9_12.9.9_1-2.9.9_12.9.9_1---
FreeBSD:15:latest2.9.102.9.10n/a2.9.10n/a---
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-setuptools>=0 : devel/py-setuptools@py311
  2. py311-wheel>=0 : devel/py-wheel@py311
  3. python3.11 : lang/python311
  4. py311-build>=0 : devel/py-build@py311
  5. py311-installer>=0 : devel/py-installer@py311
Test dependencies:
  1. python3.11 : lang/python311
Runtime dependencies:
  1. python3.11 : lang/python311
Library dependencies:
  1. libpq.so.5 : databases/postgresql16-client
This port is required by:
for Build
  1. deskutils/py-paperless-ngx

Deleted ports which required this port:

Expand this list of 4 deleted ports
  1. finance/openerp*
  2. finance/openerp-server*
  3. finance/trytond*
  4. finance/trytond28*
  5. Collapse this list of deleted ports.
for Run
  1. audio/py-supysonic
  2. databases/nagios-check_postgres_replication
  3. databases/pg_activity
  4. databases/pg_partman
  5. databases/pgbarman
  6. databases/powa-web
  7. databases/py-aiopg
Expand this list (34 items / 27 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. databases/py-pgdbconn
  3. databases/py-pgmigrate
  4. databases/py-pgspecial1
  5. databases/py-powa-collector
  6. databases/py-pum
  7. databases/py-queries
  8. deskutils/py-paperless-ngx
  9. devel/py-types-psycopg2
  10. finance/odoo
  11. finance/odoo14
  12. finance/odoo15
  13. finance/odoo16
  14. graphics/qgis
  15. graphics/qgis-ltr
  16. net/irrd
  17. net-im/py-matrix-synapse
  18. www/py-django-netfields
  19. Collapse this list.

Deleted ports which required this port:

Expand this list of 10 deleted ports
  1. databases/pgloader*
  2. databases/py-htsql-pgsql*
  3. databases/py-mysql2pgsql*
  4. databases/py-sqlalchemy06*
  5. databases/py-sqlkit*
  6. finance/openerp*
  7. finance/openerp-server*
  8. finance/trytond*
  9. finance/trytond28*
  10. net-mgmt/noc*
  11. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

Configuration Options:
No options to configure
Options name:
databases_py-psycopg2
USES:
pgsql python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/p/psycopg2/
  2. https://pypi.org/packages/source/p/psycopg2/
Collapse this list.

There are no commits on branch 2023Q1 for this port