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-pyPgSQL Python DB-API 2.0 compliant interface to PostgreSQL
2.5.1_7 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. 2.5.1_7Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: Uses deprecated version of python
Expiration Date EXPIRATION DATE: 2020-08-15
Maintainer: portmaster@BSDforge.com search for ports maintained by this maintainer
Port Added: 2001-11-02 12:00:28
Last Update: 2020-03-01 20:27:42
SVN Revision: 527601

People watching this port, also watch: gnupg, curl, py27-mx-base, libiconv, mailman

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

There is no configure plist information for this port.

Dependency lines:
  • py27-pyPgSQL>0:databases/py-pyPgSQL
To install the port: cd /usr/ports/databases/py-pyPgSQL/ && make install clean
To add the package: pkg install py27-pyPgSQL
PKGNAME: py27-pyPgSQL
Package flavors (<flavor>: <package>)
  • py27: py27-pyPgSQL
distinfo:
Packages:
py27-pyPgSQL
ABIlatestquarterly
FreeBSD:11:aarch642.5.1_52.5.1_7
FreeBSD:11:amd642.5.1_72.5.1_7
FreeBSD:11:armv62.5.1_42.5.1_7
FreeBSD:11:i3862.5.1_72.5.1_7
FreeBSD:11:mips2.5.1_42.5.1_7
FreeBSD:11:mips642.5.1_42.5.1_7
FreeBSD:12:aarch642.5.1_52.5.1_7
FreeBSD:12:amd642.5.1_72.5.1_7
FreeBSD:12:armv62.5.1_52.5.1_7
FreeBSD:12:armv72.5.1_52.5.1_7
FreeBSD:12:i3862.5.1_72.5.1_7
FreeBSD:12:mips2.5.1_52.5.1_7
FreeBSD:12:mips642.5.1_52.5.1_7
FreeBSD:12:powerpc64-2.5.1_7
FreeBSD:13:aarch642.5.1_7-
FreeBSD:13:amd642.5.1_7-
FreeBSD:13:armv62.5.1_7-
FreeBSD:13:armv72.5.1_7-
FreeBSD:13:i3862.5.1_7-
FreeBSD:13:mips2.5.1_7-
FreeBSD:13:mips64--
FreeBSD:13:powerpc642.5.1_7-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py27-setuptools>0 : devel/py-setuptools@py27
  2. python2.7 : lang/python27
Runtime dependencies:
  1. py27-mx-base>0 : lang/py-mx-base@py27
  2. py27-setuptools>0 : devel/py-setuptools@py27
  3. python2.7 : lang/python27
Library dependencies:
  1. libpq.so.5 : databases/postgresql11-client
This port is required by:
for Run

    Deleted ports which required this port:

    Expand this list of 1 deleted port
    1. databases/pgworksheet*
    2. 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. http://downloads.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  2. http://excellmedia.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  3. http://freefr.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  4. http://jaist.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  5. http://kent.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  6. http://nchc.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  7. http://netcologne.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  8. http://netix.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  9. http://superb-dca2.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  10. http://superb-sea2.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  11. http://ufpr.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  12. http://vorboss.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  13. https://downloads.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  14. https://excellmedia.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  15. https://freefr.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  16. https://jaist.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  17. https://kent.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  18. https://nchc.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  19. https://netcologne.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  20. https://netix.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  21. https://superb-dca2.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  22. https://superb-sea2.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  23. https://ufpr.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
  24. https://vorboss.dl.sourceforge.net/project/pypgsql/pypgsql/2.5.1/
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: 40

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
01 Mar 2020 20:27:42
Original commit files touched by this commit  2.5.1_7
Revision:527601
antoine search for other commits by this committer
Deprecate a few python 2.7 ports

With hat:	portmgr
26 Jul 2019 20:46:57
Original commit files touched by this commit  2.5.1_7
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
12 Dec 2018 01:35:36
Original commit files touched by this commit  2.5.1_6
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
22 May 2018 13:15:13
Original commit files touched by this commit  2.5.1_5
Revision:470610
mat search for other commits by this committer
Add PY_FLAVOR to Python module dependencies.

Sponsored by:	Absolight
11 May 2018 07:27:12
Original commit files touched by this commit  2.5.1_5
Revision:469614
koobs search for other commits by this committer
databases/py-pyPgSQL: Unmark BROKEN, Update MAINTAINER

This port was marked BROKEN/DEPRECATED due to a corrupt patch file. Update the
patch source to fix the issue.  Update MAINTAINER at submitters request.

While here, level up ports / python port compliance:

- Strip shared libraries
- Use option helpers
- Use python autoplist
- Match upstream setup.py metadata (COMMENT)
- Use explicit/canonical python package dependencies
- Unmute INSTALL_* commands

PR:		228119
Submitted by:	Chris Hutchinson <portmaster bsdforge com>
Approved by:	koobs (python, maintainer)
05 May 2018 10:49:36
Original commit files touched by this commit  2.5.1_4
Revision:469100
antoine search for other commits by this committer
Deprecate ports broken for more than 6 months
02 Dec 2017 10:20:17
Original commit files touched by this commit  2.5.1_4
Revision:455341  Sanity Test Failure
antoine search for other commits by this committer
pyPgSQL doesn't build with python3
14 Oct 2017 16:31:35
Original commit files touched by this commit  2.5.1_4
Revision:452070
bapt search for other commits by this committer
Mark as broken ports with invalid distfiles or no public distfiles
01 Apr 2016 14:00:57
Original commit files touched by this commit  2.5.1_4
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
17 Aug 2015 14:20:41
Original commit files touched by this commit  2.5.1_4
Revision:394508
mat search for other commits by this committer
Remove UNIQUENAME and LATEST_LINK.

UNIQUENAME was never unique, it was only used by USE_LDCONFIG and now,
we won't have conflicts there.

Use PKGBASE instead of LATEST_LINK in PKGLATESTFILE, the *only* consumer
is pkg-devel, and it works just fine without LATEST_LINK as pkg-devel
has the correct PKGNAME anyway.

Now that UNIQUENAME is gone, OPTIONSFILE is too. (it's been called
OPTIONS_FILE now.)

Reviewed by:	antoine, bapt
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D3336
20 Oct 2014 10:41:13
Original commit files touched by this commit  2.5.1_4
Revision:371255
bapt search for other commits by this committer
Cleanup plist
08 Oct 2014 17:16:34
Original commit files touched by this commit  2.5.1_4
Revision:370468
bapt search for other commits by this committer
Convert to USES=pgsql and USES=python
10 Jun 2014 07:39:02
Original commit files touched by this commit  2.5.1_4
Revision:357277
olgeni search for other commits by this committer
Remove indefinite articles and trailing periods from COMMENT, plus
minor COMMENT typos and surrounding whitespace fixes. Categories D-F.

CR:		D196
Approved by:	portmgr (bapt)
24 Jan 2014 19:02:48
Original commit files touched by this commit  2.5.1_4
Revision:340923
mva search for other commits by this committer
- Enable stagedir support
20 Sep 2013 16:13:49
Original commit files touched by this commit  2.5.1_4
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)
08 Jan 2013 07:06:25
Original commit files touched by this commit  2.5.1_4
Revision:310073
bapt search for other commits by this committer
Convert last python@ ports to new options framework
for both make options work as expected (previous version were missing include
<bsd.port.options.mk>)
for databases/py-pyPgSQL reverse the logic for the option test so that it
actually works as expected

Approved by:	python (crees)
22 Oct 2011 23:50:23
Original commit files touched by this commit  2.5.1_4

eadler search for other commits by this committer
- remove maintainer tags from pkg-descr

Approved by:    portmgr
Approved by:    bapt (mentor)
20 Mar 2011 12:54:45
Original commit files touched by this commit  2.5.1_4

miwi search for other commits by this committer
- Get Rid MD5 support
10 Sep 2010 04:18:06
Original commit files touched by this commit  2.5.1_4

pgollucci search for other commits by this committer
PostgreSQL 8.3.1 has changed it's bytea encoding.

* in PostgreSQL 8.3.1 Release note
Make encode(bytea, 'escape') convert all high-bit-set byte values into \nnn
octal escape sequences (Tom)

This is necessary to avoid encoding problems when the database encoding is
multi-byte. This change could pose compatibility issues for applications that
are expecting specific results from encode.

but pyPgSQL escape bytea encode as it's own implementments. PostgreSQL says that
it may make failure(see PQescapeBytea documentation).

in PQescapeBytea function documentation:
"The only difference from PQescapeByteaConn is that PQescapeBytea does not take
a PGconn parameter. Because of this, it cannot adjust its behavior depending on
the connection properties (in particular, whether standard-conforming strings
are enabled) and therefore it might give the wrong results. Also, it has no way
to return an error message on failure."

Patch is included upstream already

PR:             ports/122616
Submitted by:   "Choe, Cheng-Dae" <whitekid@gmail.com>
22 Aug 2009 00:18:43
Original commit files touched by this commit  2.5.1_3

amdmi3 search for other commits by this committer
- Switch SourceForge ports to the new File Release System: categories starting
with D
06 Jun 2008 13:17:10
Original commit files touched by this commit  2.5.1_3

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)
20 Jun 2007 21:24:22
Original commit files touched by this commit  2.5.1_2

lwhsu search for other commits by this committer
- EXAMPLES should be omitted when NOPORTEXAMPLES is defined

Noticed by:     sat
20 Jun 2007 15:57:27
Original commit files touched by this commit  2.5.1_1

lwhsu search for other commits by this committer
- Honour PKGNAMEPREFIX [1]
- Use DOCSDIR, EXAMPLESDIR in pkg-plist
- Things under EXAMPLESDIR should not be controlled by NOPORTDOCS
- Minor fix to pet portlint(1)
- Grab maintainership for python@
- Bump PORTREVISION

PR:             ports/113876 [1]
Submitted by:   Greg Skafte <skafte AT trollkarl.net>
08 Jul 2006 05:29:20
Original commit files touched by this commit  2.5.1

rafan search for other commits by this committer
- Update to 2.5.1

Approved by:    delphij (mentor, implicit)
24 Nov 2005 01:23:57
Original commit files touched by this commit  2.4_2

pav search for other commits by this committer
- Add SHA256
05 Mar 2005 22:09:34
Original commit files touched by this commit  2.4_2

vs search for other commits by this committer
Reset maintainer on request. Thanks to Gerhard for maintaining the
ports so far!

PR:             ports/78088
31 Jan 2005 00:35:56
Original commit files touched by this commit  2.4_2

girgen search for other commits by this committer
Split the postgresql ports into a server and a client part.

All ports depending on postgresql shall use the USE_PGSQL=yes knob
defined in Mk/bsd.ports.mk. Bumping portrevisions where needed.

PR:             75344
Approved by:    portmgr@ (kris), ade & sean (mentors)
31 Mar 2004 03:12:58
Original commit files touched by this commit  2.4_1

trevor search for other commits by this committer
SIZEify (maintainer timeout)
04 Feb 2004 05:21:48
Original commit files touched by this commit  2.4_1

marcus search for other commits by this committer
Bump PORTREVISION on all ports that depend on gettext to aid with upgrading.

(Part 2)
31 Jul 2003 06:50:03
Original commit files touched by this commit  2.4

daichi search for other commits by this committer
update databases/py-pyPgSQL: 2.3 -> 2.4

PR:             55084
Submitted by:   Gerhard Haering <gh@ghaering.de>
21 Feb 2003 11:15:05
Original commit files touched by this commit  2.3

knu search for other commits by this committer
De-pkg-comment.
04 Jan 2003 16:17:27
Original commit files touched by this commit  2.3

seanc search for other commits by this committer
Missed configure scripts in libpq version bump: chase lib version.
02 Jan 2003 19:28:46
Original commit files touched by this commit  2.3

ijliao search for other commits by this committer
upgrade to 2.3

PR:             46099
Submitted by:   maintainer
05 Oct 2002 23:12:29
Original commit files touched by this commit  2.2

pat search for other commits by this committer
Respect LOCALBASE and remove py-mx-base as a build dependency.
Use tab in place of whitespace as well.

PR:             ports/43570
Submitted by:   maintainer
16 Sep 2002 13:57:56
Original commit files touched by this commit  2.2

ijliao search for other commits by this committer
- update port to pyPgSQL 2.2
- updated maintainer email address
- use REINPLACE instead of PERL

PR:             42560
Submitted by:   maintainer
09 Jun 2002 16:06:47
Original commit files touched by this commit  2.1

pat search for other commits by this committer
Update to 2.1

--
also make a cosmetic change
space -> tabs
INSTALL_MAN -> INSTALL_DATA for installing port docs
perl -> ${PERL}

PR:             39051
Submitted by:   maintainer
29 Apr 2002 13:33:57
Original commit files touched by this commit  2.0

ijliao search for other commits by this committer
use USE_PYDISTUTILS
19 Mar 2002 18:27:05
Original commit files touched by this commit  2.0

petef search for other commits by this committer
Update to work with PostgreSQL 7.2.

PR:             36102
Submitted by:   maintainer
10 Nov 2001 07:01:33
Original commit files touched by this commit

nbm search for other commits by this committer
Update of the py-pyPGSQL port to version 2.0.    
02 Nov 2001 15:00:28
Original commit files touched by this commit

nbm search for other commits by this committer
Add pyPgSQL, a Python DB-API 2 compliant library for using PostgreSQL  
databases    

Number of commits found: 40

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
giteaMay 31
powerdns-recursor*May 29
gitlab-ceMay 28
rubygem-kaminari-coreMay 28
sane-backendsMay 28
sympaMay 26
chromiumMay 24
piwigoMay 23
drupal7May 22
sympaMay 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22

16 vulnerabilities affecting 89 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-31 11:54:41


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39474
Broken 85
Deprecated 625
Ignore 330
Forbidden 5
Restricted 147
No CDROM 77
Vulnerable 23
Expired 18
Set to expire 575
Interactive 0
new 24 hours 6
new 48 hours10
new 7 days32
new fortnight75
new month186

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