notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
py-pgcli CLI for Postgres Database with auto-completion and syntax highlighting
2.1.1 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
1.11.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: 2019-05-31 11:27:59
SVN Revision: 503136
Also Listed In: python
License: BSD3CLAUSE
pgcli is a command line interface for Postgres with auto-completion and syntax
highlighting.

WWW: https://pypi.org/project/pgcli/
WWW: https://www.pgcli.com/
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • py36-pgcli>0:databases/py-pgcli

To install the port: cd /usr/ports/databases/py-pgcli/ && make install clean
To add the package: pkg install py36-pgcli

PKGNAME: py36-pgcli

Package flavors (<flavor>: <package>)
  • py36: py36-pgcli
  • py27: py27-pgcli

distinfo:

TIMESTAMP = 1559293001
SHA256 (pgcli-2.1.1.tar.gz) = 84e0817a29c3cacaaaf85351422bdb90f230f2550e4af558c25536fd235ab6ca
SIZE (pgcli-2.1.1.tar.gz) = 115729


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. py36-setuptools>0 : devel/py-setuptools@py36
  2. python3.6 : lang/python36
Runtime dependencies:
  1. py36-cli-helpers>=1.2.0 : devel/py-cli-helpers@py36
  2. py36-click>=4.1 : devel/py-click@py36
  3. py36-configobj>=5.0.6 : devel/py-configobj@py36
  4. py36-humanize>=0.5.1 : devel/py-humanize@py36
  5. py36-pgspecial>=1.11.5 : databases/py-pgspecial@py36
  6. py36-prompt_toolkit>=2.0.6<2.1.0 : devel/py-prompt_toolkit@py36
  7. py36-psycopg2>=2.7.4 : databases/py-psycopg2@py36
  8. py36-pygments>=2.0 : textproc/py-pygments@py36
  9. py36-setproctitle>=1.1.9 : devel/py-setproctitle@py36
  10. py36-sqlparse>=0.3.0<0.4 : databases/py-sqlparse@py36
  11. py36-setuptools>0 : devel/py-setuptools@py36
  12. python3.6 : lang/python36
Library dependencies:
  1. libpq.so.5 : databases/postgresql95-client
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
pgsql python

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: 27

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
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: 27

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
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
firefox*Jul 23
firefox*Jul 23
firefox*Jul 23
firefox*Jul 23
firefox*Jul 23
firefox*Jul 23
firefox*Jul 23
firefox-esr*Jul 23
firefox-esr*Jul 23
firefox-esr*Jul 23
firefox-esr*Jul 23
firefox-esr*Jul 23
firefox-esr*Jul 23
firefox-esr*Jul 23
libxul*Jul 23

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

* - modified, not new

All vulnerabilities

Last updated:
2019-07-23 02:57:52


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 37005
Broken 94
Deprecated 101
Ignore 327
Forbidden 3
Restricted 162
No CDROM 74
Vulnerable 37
Expired 14
Set to expire 70
Interactive 0
new 24 hours 5
new 48 hours8
new 7 days26
new fortnight55
new month118

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