notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
py-psycopg2 High performance Python adapter for PostgreSQL
2.8.3_1 databases on this many watch lists=8 search for ports that depend on this port Find issues related to this port Report an issue related to this port 2.8.3Version of this port present on the latest quarterly branch.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2006-08-10 19:35:33
Last Update: 2019-07-26 21:46:57
SVN Revision: 507372
Also Listed In: python
License: LGPL3
Description:
SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:
  • py36-psycopg2>0:databases/py-psycopg2
To install the port: cd /usr/ports/databases/py-psycopg2/ && make install clean
To add the package: pkg install py36-psycopg2
PKGNAME: py36-psycopg2
Package flavors (<flavor>: <package>)
  • py36: py36-psycopg2
  • py27: py27-psycopg2
distinfo:

Dependencies
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-setuptools>0 : devel/py-setuptools@py36
  2. python3.6 : lang/python36
Library dependencies:
  1. libpq.so.5 : databases/postgresql95-client
This port is required by:
for Build
  1. finance/trytond28
Deleted ports
Expand this list of 3 deleted ports
  1. finance/openerp*
  2. finance/openerp-server*
  3. finance/trytond*
Collapse this list of deleted ports.
for Run
  1. databases/nagios-check_postgres_replication
  2. databases/pg_activity
  3. databases/pg_partman
  4. databases/pgbarman
  5. databases/pgloader
  6. databases/powa-web
  7. databases/py-Pyrseas
  8. Expand this list (24 items / 17 hidden)
  9. databases/py-aiopg
  10. databases/py-htsql-pgsql
  11. databases/py-mysql2pgsql
  12. databases/py-pgcli
  13. databases/py-pgdbconn
  14. databases/py-pum
  15. databases/py-queries
  16. finance/trytond28
  17. graphics/qgis
  18. graphics/qgis-ltr
  19. net-mgmt/netbox
  20. Collapse this list.
Deleted ports
Expand this list of 6 deleted ports
  1. databases/py-sqlalchemy06*
  2. databases/py-sqlkit*
  3. finance/openerp*
  4. finance/openerp-server*
  5. finance/trytond*
  6. net-mgmt/noc*
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

USES:

Master Sites:
  1. https://files.pythonhosted.org/packages/source/p/psycopg2/
  2. https://pypi.org/packages/source/p/psycopg2/
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
    
    
Port Moves
  • port moved here from databases/py-psycopg on 2016-05-29
    REASON: Has expired: This port is obsoleted by databases/py-psycopg2

Number of commits found: 58

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
26 Jul 2019 20:46:57
Original commit files touched by this commit  2.8.3_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
14 Jun 2019 20:20:00
Original commit files touched by this commit  2.8.3
Revision:504205
sunpoet search for other commits by this committer
Update to 2.8.3

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
25 May 2019 22:03:15
Original commit files touched by this commit  2.8.2
Revision:502646
sunpoet search for other commits by this committer
Update to 2.8.2

- Update MASTER_SITES

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
23 Jan 2019 17:34:57
Original commit files touched by this commit  2.7.7
Revision:491050
sunpoet search for other commits by this committer
Update to 2.7.7

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
12 Dec 2018 01:35:36
Original commit files touched by this commit  2.7.6.1_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
12 Nov 2018 21:28:07
Original commit files touched by this commit  2.7.6.1
Revision:484831
sunpoet search for other commits by this committer
Update to 2.7.6.1

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
		https://github.com/psycopg/psycopg2/blob/2_7_6_1/NEWS
11 Nov 2018 18:18:59
Original commit files touched by this commit  2.7.6
Revision:484714
sunpoet search for other commits by this committer
Update to 2.7.6

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
26 Aug 2018 18:42:33
Original commit files touched by this commit  2.7.5
Revision:478156
sunpoet search for other commits by this committer
Fix build with Python 3.7

PR:		230064
Submitted by:	amdmi3, Kamigishi Rei <spambox@haruhiism.net>
24 Jun 2018 20:16:52
Original commit files touched by this commit  2.7.5
Revision:473229
sunpoet search for other commits by this committer
Update to 2.7.5

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
09 Feb 2018 14:07:41
Original commit files touched by this commit  2.7.4
Revision:461298
sunpoet search for other commits by this committer
Update to 2.7.4

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
30 Nov 2017 15:50:34
Original commit files touched by this commit  2.7.3.2
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)
25 Oct 2017 18:28:48
Original commit files touched by this commit  2.7.3.2
Revision:452876
sunpoet search for other commits by this committer
Update to 2.7.3.2

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
27 Aug 2017 17:31:55
Original commit files touched by this commit  2.7.3.1
Revision:448827
sunpoet search for other commits by this committer
Update to 2.7.3.1

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
25 Jul 2017 16:21:35
Original commit files touched by this commit  2.7.3
Revision:446598
sunpoet search for other commits by this committer
Update to 2.7.3

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
		http://initd.org/psycopg/articles/2017/07/24/psycopg-273-released/
23 Jul 2017 13:12:45
Original commit files touched by this commit  2.7.2
Revision:446469
sunpoet search for other commits by this committer
Update to 2.7.2

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
		http://initd.org/psycopg/articles/2017/07/22/psycopg-272-released/
24 Apr 2017 15:16:42
Original commit files touched by this commit  2.7.1
Revision:439306
sunpoet search for other commits by this committer
Update to 2.7.1

- Add LICENSE_FILE
- Add GitHub repository to WWW

Changes:	https://github.com/psycopg/psycopg2/blob/master/NEWS
		http://initd.org/psycopg/articles/2017/03/13/psycopg-271-released/
		http://initd.org/psycopg/articles/2017/03/01/psycopg-27-released/
10 Dec 2016 13:39:22
Original commit files touched by this commit  2.6.2
Revision:428295
antoine search for other commits by this committer
Move py35-mysqlclient and py35-psycopg2 to match existing naming convention
14 Nov 2016 16:16:16
Original commit files touched by this commit  2.6.2
Revision:426120
cmt search for other commits by this committer
update to 2.6.2

PR:		213669
Approved by:	rene (mentor), sunpoet (maintainer-timeout)
02 Sep 2015 17:03:24
Original commit files touched by this commit  2.6.1_1
Revision:395874
sunpoet search for other commits by this committer
- Strip shared library
- Bump PORTREVISION for package change
02 Sep 2015 08:54:04
Original commit files touched by this commit  2.6.1
Revision:395825
sunpoet search for other commits by this committer
- Convert to new options target helper
12 Jul 2015 16:07:11
Original commit files touched by this commit  2.6.1
Revision:391788
sunpoet search for other commits by this committer
- Update to 2.6.1

Changes:	http://initd.org/psycopg/articles/2015/06/16/psycopg-261-released/
		http://initd.org/psycopg/articles/2015/02/09/psycopg-26-and-255-released/
18 Feb 2015 16:19:37
Original commit files touched by this commit  2.5.5
Revision:379234
sunpoet search for other commits by this committer
- Update to 2.5.5

Changes:	http://initd.org/psycopg/articles/2015/02/09/psycopg-26-and-255-released/
24 Nov 2014 18:29:59
Original commit files touched by this commit  2.5.4
Revision:373302
sunpoet search for other commits by this committer
- Update to 2.5.4
- Add LICENSE
- Add DOCS and EXAMPLES to OPTIONS_DEFINE

Changes:	http://initd.org/psycopg/articles/2014/08/30/psycopg-254-released/
23 Nov 2014 09:24:49
Original commit files touched by this commit  2.5.3_1
Revision:373136
sunpoet search for other commits by this committer
- Take maintainership
18 Nov 2014 09:37:33
Original commit files touched by this commit  2.5.3_1
Revision:372709
bapt search for other commits by this committer
Reset miwi's maintainership per his demand

Hope to see you back! Thank for all the work!
07 Oct 2014 14:45:39
Original commit files touched by this commit  2.5.3_1
Revision:370346
wg search for other commits by this committer
databases/py-psycopg2: allow concurrent install

- USES pgsql python

With hat:	python
Reported by:	Richard Kuhns (via freebsd-python@)
25 May 2014 10:12:58
Original commit files touched by this commit  2.5.3
Revision:355154
miwi search for other commits by this committer
- Update to 2.5.3
26 Jan 2014 23:32:06
Original commit files touched by this commit  2.5.2
Revision:341308
rm search for other commits by this committer
- convert to autogenerated packing list to fix python3 packaging
- simplify DOCS and EXAMPLES installation

PR:		182422
Reported by:	    Arseny Nasokin <eirnym@gmail.com>
Approved by:	miwi (maintainer, by email)
25 Jan 2014 06:05:36
Original commit files touched by this commit  2.5.2
Revision:340991
miwi search for other commits by this committer
- Stage support
15 Jan 2014 03:02:18
Original commit files touched by this commit  2.5.2
Revision:339740
miwi search for other commits by this committer
- Update to 2.5.2
20 Sep 2013 16:13:49
Original commit files touched by this commit  2.5.1
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
11 Jul 2013 15:21:14
Original commit files touched by this commit  2.5.1
Revision:322774
miwi search for other commits by this committer
- Update to 2.5.1

PR:		180177
Submitted by:	Douglas Carmichael <dcarmich@dcarmichael.net>
04 Feb 2013 02:32:33
Original commit files touched by this commit  2.4.6
Revision:311557
miwi search for other commits by this committer
 - Update to 2.4.6
 - Convert Header
10 Apr 2012 06:49:51
Original commit files touched by this commit  2.4.5

miwi search for other commits by this committer
- Update to 2.4.5

PR:             166529
Submitted by:   rm@
28 Dec 2011 09:25:06
Original commit files touched by this commit  2.4.4

rm search for other commits by this committer
- update to 2.4.4
- change USE_PYTHON to `yes' (Python3 is supported)
- update WWW
- sort pkg-plist

Approved by:   miwi (mentor)
25 Jun 2011 06:41:16
Original commit files touched by this commit  2.4.2

miwi search for other commits by this committer
- Update to 2.4.2
12 Jun 2011 02:28:11
Original commit files touched by this commit  2.4.1

miwi search for other commits by this committer
- Update to 2.4.1

PR:             156999
Submitted by:   Ruslan Mahmatkhanov <cvs-src@yandex.ru>
04 Mar 2011 14:09:31
Original commit files touched by this commit  2.4

miwi search for other commits by this committer
- Update to 2.4
25 Feb 2011 00:12:12
Original commit files touched by this commit  2.3.2_1
  Sanity Test Failure
miwi search for other commits by this committer
- Move over to py25+ or above
- While here kick md5 support
29 Jan 2011 14:14:58
Original commit files touched by this commit  2.3.2

miwi search for other commits by this committer
- Update to 2.3.2
- Cleanup

PR:             153463
Submitted by:   Khee Chin <kheechin@gmail.com>
                Ruslan Mahmatkhanov <cvs-src@yandex.ru>
Feature safe:   yes
06 Oct 2010 14:11:49
Original commit files touched by this commit  2.2.2

jpaetzel search for other commits by this committer
Update to 2.2.2
Adjust MASTER_SITE to account for upstream server crash

PR:     ports/149914
Submitted by:   Josh Paetzel <jpaetzel@FreeBSD.org>
Sponsored by:   iXsystems
24 May 2010 10:13:02
Original commit files touched by this commit  2.2.1

miwi search for other commits by this committer
- Update to 2.2.1

PR:             146800
Submitted by:   Daniel Gerzo <danger@freebsd.org> (maintainer)
14 Mar 2010 10:33:45
Original commit files touched by this commit  2.0.14

miwi search for other commits by this committer
- Update to 2.0.14
30 Oct 2009 09:47:58
Original commit files touched by this commit  2.0.13

miwi search for other commits by this committer
- Update to 2.0.13

PR:             139665
Submitted by:   Sylvio Cesar <scjamorim@bsd.com.br>
03 Sep 2009 21:56:21
Original commit files touched by this commit  2.0.12

miwi search for other commits by this committer
- Update to 2.0.12
30 May 2009 18:42:34
Original commit files touched by this commit  2.0.11

miwi search for other commits by this committer
- Update to 2.0.11
10 May 2009 17:34:35
Original commit files touched by this commit  2.0.10

miwi search for other commits by this committer
- Update to 2.0.10
01 Mar 2009 13:32:52
Original commit files touched by this commit  2.0.9

miwi search for other commits by this committer
- Update to 2.0.9
22 Sep 2008 23:47:12
Original commit files touched by this commit  2.0.8

miwi search for other commits by this committer
- Update to 2.0.8
06 Jun 2008 13:17:10
Original commit files touched by this commit  2.0.7_1

edwin search for other commits by this committer
Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)
16 May 2008 18:57:21
Original commit files touched by this commit  2.0.7

miwi search for other commits by this committer
- Update to 2.0.7

PR:             123578
Submitted by:   olli hauer <ohauer@gmx.de>
22 Dec 2007 23:11:40
Original commit files touched by this commit  2.0.6

miwi search for other commits by this committer
- Remove unnecessary dependencies

Submitted by:   Josh Paetzel via irc
04 Aug 2007 11:41:31
Original commit files touched by this commit  2.0.6

gabor search for other commits by this committer
- Remove the DESTDIR modifications from individual ports as we have a new,
  fully chrooted DESTDIR, which does not need such any more.

Sponsored by:   Google Summer of Code 2007
Approved by:    portmgr (pav)
02 Jul 2007 15:23:00
Original commit files touched by this commit  2.0.6

miwi search for other commits by this committer
- Update to 2.0.6
- Respect NOPORTEXAMPLES
- Drop FreeBSD 4.X gruft
18 Jan 2007 00:43:18
Original commit files touched by this commit  2.0.5.1_1

miwi search for other commits by this committer
- Fix build with gcc 4.X

PR:             108063
Submitted by:   trasz <trasz@pin.if.uz.zgora.pl>
22 Nov 2006 20:23:52
Original commit files touched by this commit  2.0.5.1

miwi search for other commits by this committer
- Add backup MASTER_SITES
02 Sep 2006 13:48:03
Original commit files touched by this commit  2.0.5.1

miwi search for other commits by this committer
- Update to 2.0.5.1

- Changlog here: http://initd.org/pub/software/psycopg/ChangeLog
10 Aug 2006 19:35:17
Original commit files touched by this commit  2.0.4

miwi search for other commits by this committer
psycopg2 is a PostgreSQL database adapter for the Python programming language.
It was written from scratch with the aim of being small, fast and stable. It
supports the full Python DBAPI-2.0 and is thread safe.

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

WWW: http://initd.org/projects/psycopg2

Approved by:    krion (mentor)

Number of commits found: 58

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
libgit2Aug 18
xdmAug 18
apache24Aug 17
userminAug 17
webminAug 17
cupsAug 16
libnghttp2Aug 16
nghttp2Aug 16
doas*Aug 15
traefikAug 15
nginx*Aug 14
nginx-devel*Aug 14
gitlab-ceAug 13
rubygem-nokogiriAug 13
broAug 09

14 vulnerabilities affecting 83 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-08-19 00:24:32


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 37240
Broken 456
Deprecated 145
Ignore 713
Forbidden 3
Restricted 162
No CDROM 74
Vulnerable 34
Expired 8
Set to expire 115
Interactive 0
new 24 hours 4
new 48 hours16
new 7 days31
new fortnight69
new month120

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