notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Two new features

Two two features were added on 2020-05-30:
  1. Repology links - each port now has a link to repology.org. See issue 148 for details.
  2. Ports I maintain report - port maintainers can now subscribe to a daily report of commits to the ports they maintain. See Watch ports I maintain at Report Subscriptions. Details at issue 138
Port details
py-pgcli CLI for Postgres Database with auto-completion and syntax highlighting
2.2.0 databases on this many watch lists=1 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. 2.2.0Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2015-12-04 12:21:45
Last Update: 2020-02-11 17:53:49
SVN Revision: 525842

People watching this port, also watch: python, py37-pyodbc, py37-urlextract, gogs, nfs-ganesha

Also Listed In: python
License: BSD3CLAUSE
Description:
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • py37-pgcli>0:databases/py-pgcli
To install the port: cd /usr/ports/databases/py-pgcli/ && make install clean
To add the package: pkg install py37-pgcli
PKGNAME: py37-pgcli
Package flavors (<flavor>: <package>)
  • py37: py37-pgcli
  • py27: py27-pgcli
distinfo:
Packages:
py27-pgcli
ABIlatestquarterly
FreeBSD:11:aarch641.10.32.2.0
FreeBSD:11:amd642.2.02.2.0
FreeBSD:11:armv60.20.12.2.0
FreeBSD:11:i3862.2.02.2.0
FreeBSD:11:mips0.20.12.2.0
FreeBSD:11:mips640.20.12.2.0
FreeBSD:12:aarch641.11.02.2.0
FreeBSD:12:amd642.2.02.2.0
FreeBSD:12:armv61.11.02.2.0
FreeBSD:12:armv71.11.02.2.0
FreeBSD:12:i3862.2.02.2.0
FreeBSD:12:mips1.11.02.2.0
FreeBSD:12:mips641.11.02.2.0
FreeBSD:12:powerpc64-2.2.0
FreeBSD:13:aarch642.2.0-
FreeBSD:13:amd642.2.0-
FreeBSD:13:armv62.2.0-
FreeBSD:13:armv72.2.0-
FreeBSD:13:i3862.2.0-
FreeBSD:13:mips2.2.0-
FreeBSD:13:mips64--
FreeBSD:13:powerpc642.2.0-
 
py36-pgcli
ABIlatestquarterly
FreeBSD:11:aarch641.10.3-
FreeBSD:11:amd64--
FreeBSD:11:armv6--
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch641.11.0-
FreeBSD:12:amd64--
FreeBSD:12:armv61.11.0-
FreeBSD:12:armv71.11.0-
FreeBSD:12:i386--
FreeBSD:12:mips1.11.0-
FreeBSD:12:mips641.11.0-
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
 
py37-pgcli
ABIlatestquarterly
FreeBSD:11:aarch64-2.2.0
FreeBSD:11:amd642.2.02.2.0
FreeBSD:11:armv6-2.2.0
FreeBSD:11:i3862.2.02.2.0
FreeBSD:11:mips-2.2.0
FreeBSD:11:mips64-2.2.0
FreeBSD:12:aarch64-2.2.0
FreeBSD:12:amd642.2.02.2.0
FreeBSD:12:armv6-2.2.0
FreeBSD:12:armv7-2.2.0
FreeBSD:12:i3862.2.02.2.0
FreeBSD:12:mips-2.2.0
FreeBSD:12:mips64-2.2.0
FreeBSD:12:powerpc64-2.2.0
FreeBSD:13:aarch642.2.0-
FreeBSD:13:amd642.2.0-
FreeBSD:13:armv62.2.0-
FreeBSD:13:armv72.2.0-
FreeBSD:13:i3862.2.0-
FreeBSD:13:mips2.2.0-
FreeBSD:13:mips64--
FreeBSD:13:powerpc642.2.0-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py37-setuptools>0 : devel/py-setuptools@py37
  2. python3.7 : lang/python37
Runtime dependencies:
  1. py37-cli-helpers>=1.2.0 : devel/py-cli-helpers@py37
  2. py37-click>=4.1 : devel/py-click@py37
  3. py37-configobj>=5.0.6 : devel/py-configobj@py37
  4. py37-humanize>=0.5.1 : devel/py-humanize@py37
  5. py37-pgspecial>=1.11.8 : databases/py-pgspecial@py37
  6. py37-prompt_toolkit>=2.0.6<3.0.0 : devel/py-prompt_toolkit@py37
  7. py37-psycopg2>=2.8 : databases/py-psycopg2@py37
  8. py37-pygments>=2.0 : textproc/py-pygments@py37
  9. py37-setproctitle>=1.1.9 : devel/py-setproctitle@py37
  10. py37-sqlparse>=0.3.0<0.4 : databases/py-sqlparse@py37
  11. py37-setuptools>0 : devel/py-setuptools@py37
  12. python3.7 : lang/python37
Library dependencies:
  1. libpq.so.5 : databases/postgresql11-client
There are no ports dependent upon this port

Configuration Options

USES:

Master Sites:
  1. https://files.pythonhosted.org/packages/source/p/pgcli/
  2. https://pypi.org/packages/source/p/pgcli/
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2017-11-30
    Affects: */py*
    Author: mat@FreeBSD.org
    Reason: 
      Ports using Python via USES=python are now flavored.  All the py3-* ports
      have been removed and folded into their py-* master ports.
    
      People using Poudriere 3.2+ and binary packages do not have to do anything.
    
      For other people, to build the Python 3.6 version of, for example,
      databases/py-gdbm, you need to run:
    
        # make FLAVOR=py36 install
    
    

Number of commits found: 30

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
11 Feb 2020 17:53:49
Original commit files touched by this commit  2.2.0
Revision:525842
sunpoet search for other commits by this committer
Update version requirement of RUN_DEPENDS
08 Dec 2019 17:01:00
Original commit files touched by this commit  2.2.0
Revision:519389
sunpoet search for other commits by this committer
Update to 2.2.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
26 Jul 2019 20:46:57
Original commit files touched by this commit  2.1.1_1
Revision:507372
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330
31 May 2019 10:27:59
Original commit files touched by this commit  2.1.1
Revision:503136
sunpoet search for other commits by this committer
Update to 2.1.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
28 May 2019 08:55:50
Original commit files touched by this commit  2.1.0_1
Revision:502867
koobs search for other commits by this committer
databases/py-pgcli: Fix runtime dependency failures

pgcli depends on sqlparse<0.3.0,>=0.2.2, and sqlparse was updated to 0.3.0
in ports r495481.

pgcli depends on psycopg2>=2.7.4,<2.8, and psycopg2 was updated to 2.8.2
in ports r502646.

These broke run time, with the following error(s)

  raise DistributionNotFound(req, requirers)
  pkg_resources.DistributionNotFound: The 'sqlparse<0.3.0,>=0.2.2' distribution
was not found and is required by pgcli

  raise DistributionNotFound(req, requirers)
  pkg_resources.DistributionNotFound: The 'psycopg2>=2.7.4,<2.8' distribution
was not found and is required by pgcli
(Only the first 15 lines of the commit message are shown above View all of this commit message)
17 Apr 2019 18:48:42
Original commit files touched by this commit  2.1.0
Revision:499188
sunpoet search for other commits by this committer
Update to 2.1.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
16 Apr 2019 23:50:10
Original commit files touched by this commit  2.0.2
Revision:499137
sunpoet search for other commits by this committer
Update to 2.0.2

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
10 Apr 2019 06:18:32
Original commit files touched by this commit  1.11.0_2
Revision:498530
antoine search for other commits by this committer
Bump a few PORTREVISIONs after r498529

With hat:	portmgr
12 Dec 2018 01:35:36
Original commit files touched by this commit  1.11.0_1
Revision:487272
gerald search for other commits by this committer
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590
25 Sep 2018 16:08:45
Original commit files touched by this commit  1.11.0
Revision:480673
sunpoet search for other commits by this committer
Update to 1.11.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
29 Jul 2018 19:15:15
Original commit files touched by this commit  1.10.3
Revision:475730
sunpoet search for other commits by this committer
Update to 1.10.3

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
20 Jun 2018 17:05:44
Original commit files touched by this commit  1.9.1
Revision:472884
mat search for other commits by this committer
Use PY_FLAVOR for dependencies.

FLAVOR is the current port's flavor, it should not be used outside of
this scope.

Sponsored by:	Absolight
25 Apr 2018 16:42:38
Original commit files touched by this commit  1.9.1
Revision:468282
amdmi3 search for other commits by this committer
Switch all pypi.python.org WWWs to a new PyPi home pypi.org where
they now redirect to anyway. All new urls checked to return 200,
I've fixed a couple of them in the process.

Approved by:	portmgr blanket, mat
06 Apr 2018 16:26:56
Original commit files touched by this commit  1.9.1
Revision:466660
sunpoet search for other commits by this committer
Update to 1.9.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
03 Mar 2018 16:30:29
Original commit files touched by this commit  1.9.0
Revision:463500
sunpoet search for other commits by this committer
Update to 1.9.0

- Update WWW

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
21 Dec 2017 17:41:06
Original commit files touched by this commit  1.8.2
Revision:456922
sunpoet search for other commits by this committer
Update to 1.8.2

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
03 Dec 2017 20:36:11
Original commit files touched by this commit  1.8.1_1
Revision:455454  Sanity Test Failure
sunpoet search for other commits by this committer
Fix py-cli-helpers dependency

- Bump PORTREVISION for package change

Obtained
from:	https://github.com/dbcli/pgcli/commit/4093a8546b330bcbd257610ea6b27219af1615aa
30 Nov 2017 15:50:34
Original commit files touched by this commit  1.8.1
Revision:455210  Sanity Test Failure
mat search for other commits by this committer
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
(Only the first 15 lines of the commit message are shown above View all of this commit message)
20 Sep 2017 16:31:56
Original commit files touched by this commit  1.8.1
Revision:450214
sunpoet search for other commits by this committer
Update to 1.8.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
15 Sep 2017 19:17:39
Original commit files touched by this commit  1.8.0
Revision:449926
sunpoet search for other commits by this committer
Update to 1.8.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
16 Jul 2017 16:09:56
Original commit files touched by this commit  1.7.0
Revision:446019
sunpoet search for other commits by this committer
Update to 1.7.0

- Add LICENSE_FILE

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
28 May 2017 23:15:02
Original commit files touched by this commit  1.6.0
Revision:441929
sunpoet search for other commits by this committer
Update to 1.6.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
15 Mar 2017 11:31:47
Original commit files touched by this commit  1.5.1
Revision:436213
sunpoet search for other commits by this committer
Update to 1.5.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
07 Mar 2017 17:02:26
Original commit files touched by this commit  1.5.0
Revision:435618
sunpoet search for other commits by this committer
Update to 1.5.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
12 Jan 2017 20:02:32
Original commit files touched by this commit  1.4.0
Revision:431303
sunpoet search for other commits by this committer
Update to 1.4.0

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
03 Dec 2016 08:32:27
Original commit files touched by this commit  1.3.1_1
Revision:427604
sunpoet search for other commits by this committer
- Allow concurrent installation (USE_PYTHON=concurrent)
- Bump PORTREVISION for package change
19 Nov 2016 17:07:47
Original commit files touched by this commit  1.3.1
Revision:426460
sunpoet search for other commits by this committer
- Update to 1.3.1

Changes:	https://github.com/dbcli/pgcli/blob/master/changelog.rst
05 Nov 2016 18:01:15
Original commit files touched by this commit  1.3.0
Revision:425415
sunpoet search for other commits by this committer
- Update to 1.3.0

Changes:	https://github.com/dbcli/pgcli/commits/master
Differential Revision:	https://reviews.freebsd.org/D8414
01 Apr 2016 14:00:57
Original commit files touched by this commit  0.20.1
Revision:412346
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
04 Dec 2015 12:21:24
Original commit files touched by this commit  0.20.1
Revision:402924
sunpoet search for other commits by this committer
- 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/

Number of commits found: 30

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?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
gitlab-ceJun 04
gnutlsJun 04
py-django22Jun 04
libnghttp2Jun 03
nghttp2Jun 03
rubygem-websocket-extensionsJun 03
giteaMay 31
powerdns-recursor*May 29
gitlab-ceMay 28
rubygem-kaminari-coreMay 28
sane-backendsMay 28
sympaMay 26
chromiumMay 24
piwigoMay 23
drupal7May 22

17 vulnerabilities affecting 90 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-06-04 18:54:31


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39487
Broken 95
Deprecated 630
Ignore 338
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 23
Expired 14
Set to expire 580
Interactive 0
new 24 hours 7
new 48 hours11
new 7 days39
new fortnight71
new month181

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.