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 2024Q2
py-psycopg2 High performance Python adapter for PostgreSQL
2.9.9_1 databases on this many watch lists=14 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-03-23 14:31:06
Commit Hash: ce63478
People watching this port, also watch:: ca_root_nss, libgcrypt, libgpg-error, libxml2, p5-Digest-HMAC
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 py39-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 py39-psycopg2 listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py39-psycopg2
Package flavors (<flavor>: <package>)
  • py39: py39-psycopg2
distinfo:
TIMESTAMP = 1696432898 SHA256 (psycopg2-2.9.9.tar.gz) = d1454bde93fb1e224166811694d600e746430c006fbb031ea06ecc2ea41bf156 SIZE (psycopg2-2.9.9.tar.gz) = 384926

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.9_12.9.9_1-2.9.9_12.9.9_1---
FreeBSD:13:quarterly2.9.9_12.9.9_1-2.9.9_12.9.9_1---
FreeBSD:14:latest2.9.9_12.9.9_1-2.9.9_12.9.9_1---
FreeBSD:14:quarterly2.9.9_12.9.9_1-2.9.9_12.9.9_1---
FreeBSD:15:latest2.9.9_12.9.9_1n/a2.9.9_1n/a---
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py39-setuptools>=0 : devel/py-setuptools@py39
  2. py39-wheel>=0 : devel/py-wheel@py39
  3. python3.9 : lang/python39
  4. py39-build>=0 : devel/py-build@py39
  5. py39-installer>=0 : devel/py-installer@py39
Test dependencies:
  1. python3.9 : lang/python39
Runtime dependencies:
  1. python3.9 : lang/python39
Library dependencies:
  1. libpq.so.5 : databases/postgresql15-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. databases/nagios-check_postgres_replication
  2. databases/pg_activity
  3. databases/pg_partman
  4. databases/pgbarman
  5. databases/powa-web
  6. databases/py-Pyrseas
  7. databases/py-aiopg
Expand this list (33 items / 26 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-pum
  6. databases/py-queries
  7. deskutils/py-paperless-ngx
  8. devel/py-types-psycopg2
  9. finance/odoo
  10. finance/odoo14
  11. finance/odoo15
  12. finance/odoo16
  13. graphics/qgis
  14. graphics/qgis-ltr
  15. net/irrd
  16. net-im/py-matrix-synapse
  17. www/py-django-netfields
  18. 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 2024Q2 for this port