databases/py-psycopg2 - The NetBSD Packages Collection

PostgreSQL database adapter for Python

psycopg is a PostgreSQL database adapter for the Python programming language
(just like pygresql and popy.) It was written from scratch with the aim of
being very small and fast, and stable as a rock. The main advantages of
psycopg are that it supports (well... *will* support) the full Python
DBAPI-2.0 and being thread safe at level 2.

psycopg 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.

This is version 2, a complete rewrite of the original code to provide
new-style classes for connection and cursor objects and other
sweet candies. Like the original, psycopg 2 was written with the aim of
being very small and fast, and stable as a rock.

Build dependencies

devel/py-setuptools pkgtools/mktools pkgtools/cwrappers

Runtime dependencies

lang/python312 lang/python312 databases/postgresql14-client databases/postgresql14-client

Binary packages

OSArchitectureVersion
NetBSD 10.0aarch64py310-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py311-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py312-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py38-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py39-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py310-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py311-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py312-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py38-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py39-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py310-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py311-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py312-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py38-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64py39-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy310-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy311-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy312-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy38-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy39-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy310-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy311-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy312-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy38-psycopg2-2.9.9.tgz
NetBSD 10.0aarch64ebpy39-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py312-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py39-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py312-psycopg2-2.9.9.tgz
NetBSD 10.0earmv4py39-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy312-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy38-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy39-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy312-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy38-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy39-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv6hfpy312-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy312-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy38-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy39-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy312-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy38-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy39-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy310-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy311-psycopg2-2.9.9.tgz
NetBSD 10.0earmv7hfpy312-psycopg2-2.9.9.tgz
NetBSD 10.0i386py310-psycopg2-2.9.9.tgz
NetBSD 10.0i386py311-psycopg2-2.9.9.tgz
NetBSD 10.0i386py312-psycopg2-2.9.9.tgz
NetBSD 10.0i386py38-psycopg2-2.9.9.tgz
NetBSD 10.0i386py39-psycopg2-2.9.9.tgz
NetBSD 10.0i386py310-psycopg2-2.9.9.tgz
NetBSD 10.0i386py311-psycopg2-2.9.9.tgz
NetBSD 10.0i386py312-psycopg2-2.9.9.tgz
NetBSD 10.0i386py38-psycopg2-2.9.9.tgz
NetBSD 10.0i386py39-psycopg2-2.9.9.tgz
NetBSD 10.0i386py310-psycopg2-2.9.9.tgz
NetBSD 10.0i386py311-psycopg2-2.9.9.tgz
NetBSD 10.0i386py312-psycopg2-2.9.9.tgz
NetBSD 10.0i386py38-psycopg2-2.9.9.tgz
NetBSD 10.0i386py39-psycopg2-2.9.9.tgz
NetBSD 10.0i386py310-psycopg2-2.9.9.tgz
NetBSD 10.0i386py311-psycopg2-2.9.9.tgz
NetBSD 10.0i386py312-psycopg2-2.9.9.tgz
NetBSD 10.0mips64ebpy310-psycopg2-2.9.9.tgz
NetBSD 10.0mips64ebpy311-psycopg2-2.9.9.tgz
NetBSD 10.0mips64ebpy312-psycopg2-2.9.9.tgz
NetBSD 10.0mips64ebpy39-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy310-psycopg2-2.9.7.tgz
NetBSD 10.0powerpcpy311-psycopg2-2.9.7.tgz
NetBSD 10.0powerpcpy38-psycopg2-2.9.7.tgz
NetBSD 10.0powerpcpy39-psycopg2-2.9.7.tgz
NetBSD 10.0powerpcpy310-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy311-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy312-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy38-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy39-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy310-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy311-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy312-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy38-psycopg2-2.9.9.tgz
NetBSD 10.0powerpcpy39-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy310-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy311-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy312-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy38-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy39-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy310-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy311-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy312-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy38-psycopg2-2.9.9.tgz
NetBSD 10.0sh3elpy39-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py310-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py311-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py312-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py38-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py39-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py310-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py311-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py312-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py38-psycopg2-2.9.9.tgz
NetBSD 10.0sparc64py39-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy310-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy311-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy312-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy38-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy39-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy310-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy311-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy312-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy38-psycopg2-2.9.9.tgz
NetBSD 10.0sparcpy39-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py38-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py39-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py38-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py39-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py38-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py39-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 10.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py310-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py311-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py312-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py38-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py39-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py310-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py311-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py312-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py38-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py39-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py310-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py311-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py312-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py38-psycopg2-2.9.9.tgz
NetBSD 9.0aarch64py39-psycopg2-2.9.9.tgz
NetBSD 9.0earmv4py310-psycopg2-2.9.9.tgz
NetBSD 9.0earmv4py311-psycopg2-2.9.9.tgz
NetBSD 9.0earmv4py312-psycopg2-2.9.9.tgz
NetBSD 9.0earmv4py39-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy310-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy311-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy38-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy39-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy310-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy311-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy38-psycopg2-2.9.9.tgz
NetBSD 9.0earmv6hfpy39-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy310-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy311-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy38-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy39-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy310-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy311-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy38-psycopg2-2.9.9.tgz
NetBSD 9.0earmv7hfpy39-psycopg2-2.9.9.tgz
NetBSD 9.0i386py310-psycopg2-2.9.9.tgz
NetBSD 9.0i386py311-psycopg2-2.9.9.tgz
NetBSD 9.0i386py312-psycopg2-2.9.9.tgz
NetBSD 9.0i386py38-psycopg2-2.9.9.tgz
NetBSD 9.0i386py39-psycopg2-2.9.9.tgz
NetBSD 9.0i386py310-psycopg2-2.9.9.tgz
NetBSD 9.0i386py311-psycopg2-2.9.9.tgz
NetBSD 9.0i386py38-psycopg2-2.9.9.tgz
NetBSD 9.0i386py39-psycopg2-2.9.9.tgz
NetBSD 9.0i386py310-psycopg2-2.9.9.tgz
NetBSD 9.0i386py311-psycopg2-2.9.9.tgz
NetBSD 9.0i386py312-psycopg2-2.9.9.tgz
NetBSD 9.0i386py38-psycopg2-2.9.9.tgz
NetBSD 9.0i386py39-psycopg2-2.9.9.tgz
NetBSD 9.0i386py310-psycopg2-2.9.9.tgz
NetBSD 9.0i386py311-psycopg2-2.9.9.tgz
NetBSD 9.0i386py312-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy310-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy311-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy312-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy38-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy39-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy310-psycopg2-2.9.7.tgz
NetBSD 9.0powerpcpy311-psycopg2-2.9.7.tgz
NetBSD 9.0powerpcpy38-psycopg2-2.9.7.tgz
NetBSD 9.0powerpcpy39-psycopg2-2.9.7.tgz
NetBSD 9.0powerpcpy310-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy311-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy312-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy38-psycopg2-2.9.9.tgz
NetBSD 9.0powerpcpy39-psycopg2-2.9.9.tgz
NetBSD 9.0sparc64py310-psycopg2-2.9.9.tgz
NetBSD 9.0sparc64py311-psycopg2-2.9.9.tgz
NetBSD 9.0sparc64py312-psycopg2-2.9.9.tgz
NetBSD 9.0sparc64py38-psycopg2-2.9.9.tgz
NetBSD 9.0sparc64py39-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py38-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py39-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py38-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py39-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py38-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py39-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py310-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py311-psycopg2-2.9.9.tgz
NetBSD 9.0x86_64py312-psycopg2-2.9.9.tgz
NetBSD 9.3x86_64py310-psycopg2-2.9.9.tgz
NetBSD 9.3x86_64py311-psycopg2-2.9.9.tgz
NetBSD 9.3x86_64py312-psycopg2-2.9.9.tgz
NetBSD 9.3x86_64py310-psycopg2-2.9.9.tgz
NetBSD 9.3x86_64py311-psycopg2-2.9.9.tgz
NetBSD 9.3x86_64py312-psycopg2-2.9.9.tgz

Binary packages can be installed with the high-level tool pkgin (which can be installed with pkg_add) or pkg_add(1) (installed by default). The NetBSD packages collection is also designed to permit easy installation from source.

Available build options

(none)

Known vulnerabilities

The pkg_admin audit command locates any installed package which has been mentioned in security advisories as having vulnerabilities.

Please note the vulnerabilities database might not be fully accurate, and not every bug is exploitable with every configuration.


Problem reports, updates or suggestions for this package should be reported with send-pr.