CVE and update status of the FreeBSD ports tree3,864 unaddressed CVEs in 671 portsAll times are CET
Port details

databases/py-pgcli 4.7.1

CLI for Postgres Database with auto-completion and syntax highlighting

Port info

Maintainer
sunpoet@FreeBSD.org
Packages
latest: 4.7.1
Upstream
up to date
Last update
to 4.7.1 · eab57e03e5
Quarterly
2026Q4: 4.7.1
WWW
https://www.pgcli.com/
Links
cgit · VuXML

Install

Package
# pkg install py312-pgcli
installs 4.7.1 from latest; from quarterly (2026Q4) 4.7.1
Port
# cd /usr/ports/databases/py-pgcli && make install clean
# make -C /usr/ports/databases/py-pgcli config  # change options first
Size
185 KiB download · 916 KiB installed
Depends on
databases/postgresql18-client 18.6, databases/py-pgspecial 2.3.0, databases/py-psycopg 3.3.6, databases/py-sqlparse 0.6.0, devel/py-cli-helpers 2.15.1, devel/py-click 8.5.0, devel/py-configobj 5.0.9, devel/py-prompt-toolkit 3.0.53, devel/py-setproctitle 1.3.7, devel/py-tzlocal 5.4.4, lang/python312 3.12.15, textproc/py-pygments 2.21.0
License
BSD3CLAUSE
Options
0 of 2 on in the package
Show the 2 options that are off
KEYRING SSHTUNNEL

Packages by version and architecture

latest

FreeBSD versionamd64aarch64i386
FreeBSD 164.7.14.7.1–
FreeBSD 154.7.14.7.1–
FreeBSD 144.7.14.7.14.7.1

quarterly (2026Q4)

FreeBSD versionamd64aarch64i386
FreeBSD 154.7.14.7.1–
FreeBSD 144.7.14.7.14.7.1

version as in the ports tree (latest) or the most common one (quarterly) · different version · ✗ not built · – no packages for this platform. Package sets that have not been rebuilt for 60 days are left out.

Unaddressed and VuXML only (0)

No unaddressed CVE and nothing reported by pkg audit for the packaged version 4.7.1.

Fixed (0)

No VuXML entries for this package.

Problem reports (0) · open in Bugzilla, most recently changed first

None.

Commits (67)

Sunpoet Po-Chuan Hsieh (sunpoet) · 1.9.1
Update to 1.9.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
e7f5b5f3a7
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.9.0
Update to 1.9.0

- Update WWW

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
ca1a9f2de9
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.8.2
Update to 1.8.2

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
6c8bed087d
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.8.1_1
Fix py-cli-helpers dependency

- Bump PORTREVISION for package change

Obtained from:	https://github.com/dbcli/pgcli/commit/4093a8546b330bcbd257610ea6b27219af1615aa
7adae7ec06
Mathieu Arnold (mat) · 1.8.1
Convert Python ports to FLAVORS.

Ports using USE_PYTHON=distutils are now flavored.  They will
  automatically get flavors (py27, py34, py35, py36) depending on what
  versions they support.

  There is also a USE_PYTHON=flavors for ports that do not use distutils
  but need FLAVORS to be set.  A USE_PYTHON=noflavors can be set if
  using distutils but flavors are not wanted.

  A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
  added to cope with Python ports that did not have the Python
  PKGNAMEPREFIX but are flavored.

  USES=python now also exports a PY_FLAVOR variable that contains the
  current python flavor.  It can be used in dependency lines when the
  port itself is not python flavored.  For example, deskutils/calibre.

  By default, all the flavors are generated.  To only generate flavors
  for the versions in PYTHON2_DEFAULT and PYTHON3_DEFAULT, define
  BUILD_DEFAULT_PYTHON_FLAVORS in your make.conf.

  In all the ports with Python dependencies, the *_DEPENDS entries MUST
  end with the flavor so that the framework knows which to build/use.
  This is done by appending '@${PY_FLAVOR}' after the origin (or
  @${FLAVOR} if in a Python module with Python flavors, as the content
  will be the same).  For example:

    RUN_DEPENDS= ${PYTHON_PKGNAMEPREFIX}six>0:devel/py-six@${PY_FLAVOR}

PR:		223071
Reviewed by:	portmgr, python
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D12464
551be3c723
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.8.1
Update to 1.8.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
1d9c54b593
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.8.0
Update to 1.8.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
af6faf86bc
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.7.0
Update to 1.7.0

- Add LICENSE_FILE

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
cdb6ade7ee
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.6.0
Update to 1.6.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
c40744f6de
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.5.1
Update to 1.5.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
7bb5c80a4a
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.5.0
Update to 1.5.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
848451b983
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.4.0
Update to 1.4.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
44b8bf8dba
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.3.1_1
- Allow concurrent installation (USE_PYTHON=concurrent) - Bump PORTREVISION for package change
0cadf887bc
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.3.1
- Update to 1.3.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
5adc303ce7
Sunpoet Po-Chuan Hsieh (sunpoet) · 1.3.0
- Update to 1.3.0

Changes:	https://github.com/dbcli/pgcli/commits/master
Differential Revision:	https://reviews.freebsd.org/D8414
303be6203d
Mathieu Arnold (mat) · 0.20.1
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
4e1b79a0a6
Sunpoet Po-Chuan Hsieh (sunpoet) · 0.20.1
- Add py-pgcli 0.20.1

pgcli is a command line interface for Postgres with auto-completion and syntax
highlighting.

WWW: https://pypi.python.org/pypi/pgcli
WWW: http://pgcli.com/
0d23c99c45