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
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
After the ports freeze to fix some stuff, the freeze is over. I have some work to do before FreshPorts can start processing commits again before it can start processing again. I've created an issue for that.
Port details on branch 2026Q2
py-psycopg PostgreSQL database adapter for Python
3.3.4 databases on this many watch lists=9 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 3.2.13Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2002-04-17 07:11:10
Last Update: 2026-07-11 12:21:00
Commit Hash: 5ecdeb2
People watching this port, also watch:: gnupg, python, libogg
Also Listed In: python
License: LGPL3
WWW:
https://www.psycopg.org/psycopg3/
https://github.com/psycopg/psycopg
Description:
PostgreSQL database adapter for Python Psycopg 3 is a modern implementation of a PostgreSQL adapter for Python.
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.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}psycopg>0:databases/py-psycopg@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-psycopg/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-psycopg
  • pkg install py312-psycopg
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 py312-psycopg listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py312-psycopg
Package flavors (<flavor>: <package>)
  • py312: py312-psycopg
distinfo:
TIMESTAMP = 1783564018 SHA256 (psycopg-3.3.4.tar.gz) = e21207764952cff81b6b8bdacad9a3939f2793367fdac2987b3aac36a651b5bc SIZE (psycopg-3.3.4.tar.gz) = 165799
Packages (timestamps in pop-ups are UTC):
py39-psycopg
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly--3.1.9--n/an/an/a
FreeBSD:14:latest--3.1.4--3.1.9-3.1.9
FreeBSD:14:quarterly-----3.1.163.1.163.1.16
FreeBSD:15:latest--n/a-n/an/a3.1.163.1.18
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 
py311-psycopg
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest3.2.133.2.13-3.2.93.2.13n/an/an/a
FreeBSD:13:quarterly3.2.133.2.13-3.2.93.2.13n/an/an/a
FreeBSD:14:latest---3.2.9----
FreeBSD:14:quarterly---3.2.9----
FreeBSD:15:latest--n/a3.2.9n/an/a--
FreeBSD:15:quarterly--n/a-n/an/a--
FreeBSD:16:latest--n/a-n/an/a--
 
py312-psycopg
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-----n/an/an/a
FreeBSD:13:quarterly-----n/an/an/a
FreeBSD:14:latest3.3.43.3.4--3.3.4---
FreeBSD:14:quarterly3.2.133.2.13--3.2.13---
FreeBSD:15:latest3.3.43.3.4n/a-n/an/a--
FreeBSD:15:quarterly3.2.133.2.13n/a-n/an/a--
FreeBSD:16:latest3.3.43.3.4n/a-n/an/a--
 
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py312-setuptools>=61 : devel/py-setuptools@py312
  2. py312-wheel>=0.37 : devel/py-wheel@py312
  3. python3.12 : lang/python312
  4. py312-build>=0 : devel/py-build@py312
  5. py312-installer>=0 : devel/py-installer@py312
Test dependencies:
  1. python3.12 : lang/python312
Runtime dependencies:
  1. py312-psycopg-c>=3.3.4<3.3.4_99 : databases/py-psycopg-c@py312
  2. py312-psycopg-pool>=0 : databases/py-psycopg-pool@py312
  3. python3.12 : lang/python312
  4. py312-typing-extensions>=4.6 : devel/py-typing-extensions@py312
Library dependencies:
  1. libpq.so.5 : databases/postgresql18-client
This port is required by:
for Build
  1. sysutils/py-healthchecks

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. finance/tinyerp-server*
  2. Collapse this list of deleted ports.
for Run
  1. databases/py-Pyrseas
  2. databases/py-harlequin-postgres
  3. databases/py-pgcli
  4. databases/py-pgspecial
  5. devel/py-pytest-postgresql
  6. net-mgmt/netbox
  7. net-mgmt/peering-manager
Expand this list (10 items / 3 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. sysutils/py-healthchecks
  3. Collapse this list.

Deleted ports which required this port:

Expand this list of 2 deleted ports
  1. finance/tinyerp-server*
  2. www/session2*
  3. 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:
===> The following configuration options are available for py312-psycopg-3.3.4: C=on: C extension support POOL=on: Connection pool support ===> Use 'make config' to modify these settings
Options name:
databases_py-psycopg
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/psycopg/
  2. https://pypi.org/packages/source/p/psycopg/
Collapse this list.

There are no commits on branch 2026Q2 for this port
Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
elixirAug 28
elixir-develAug 28
gitlabAug 28
nsdAug 27
php-composerAug 27
conduitAug 26
openssl*Aug 26
openssl*Aug 26
openssl34*Aug 26
openssl34*Aug 26
openssl35*Aug 26
openssl35*Aug 26
openssl36*Aug 26
openssl36*Aug 26
openssl40*Aug 26

27 vulnerabilities affecting 432 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2026-08-28 13:26:40 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 35101
Broken 78
Deprecated 335
Ignore 192
Forbidden 0
Restricted 1
No CDROM 1
Vulnerable 42
Expired 18
Set to expire 260
Interactive 0
new 24 hours 1
new 48 hours9
new 7 days39
new fortnight93
new month193
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2026 Dan Langille. All rights reserved.