notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

FInally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combinatio for a given watch list. This is what FreshPorts will look for.

Port details
py-pyPgSQL Python DB-API 2.0 compliant interface to PostgreSQL
2.5.1_7 databases Deleted 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. pkg-fallout 2.5.1_7Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: Uses deprecated version of python
Expired This port expired on: 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-08-15 10:50:59
SVN Revision: 544927
People watching this port, also watch:: gnupg, curl, libiconv, mailman
Also Listed In: python
License: BSD2CLAUSE
WWW:
http://pypgsql.sourceforge.net/
Description:
pyPgSQL is a package of two modules that provide a Python DB-API 2.0 compliant interface to PostgreSQL databases. The first module, libpq, exports the PostgreSQL C API to Python. This module is written in C and can be compiled into Python or can be dynamically loaded on demand. The second module, PgSQL, provides the DB-API 2.0 compliant interface and support for various PostgreSQL data types, such as INT8, NUMERIC, MONEY, BOOL, ARRAYS, etc. This module is written in Python. WWW: http://pypgsql.sourceforge.net/ developed by Bill Allie et al
Homepage    cgit ¦ GitHub ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}pyPgSQL>0:databases/py-pyPgSQL@${PY_FLAVOR}
No installation instructions:
This port has been deleted.
PKGNAME: py27-pyPgSQL
Package flavors (<flavor>: <package>)
  • py27: py27-pyPgSQL
distinfo:
TIMESTAMP = 1526023581 SHA256 (pyPgSQL-2.5.1.tar.gz) = 498486f066f11a68f5b02a54ba5a008d01d507038c873bfd901c14d3f5ca18af SIZE (pyPgSQL-2.5.1.tar.gz) = 152840

No package information for this port in our database
Sometimes this happens. Not all ports have packages.
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
NOTE: dependencies for deleted ports are notoriously suspect
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:
===> The following configuration options are available for py27-pyPgSQL-2.5.1_7: BYTEA_CONN=on: Apply Bytea connection patch DOCS=on: Build and/or install documentation EXAMPLES=on: Build and/or install examples ===> Use 'make config' to modify these settings
Options name:
N/A
USES:
pgsql python:2.7
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (24 items)
Collapse this list.
  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/
Collapse this list.

Number of commits found: 41

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
2.5.1_7
15 Aug 2020 10:50:59
Revision:544927Original commit files touched by this commit
rene search for other commits by this committer
Remove deprecated ports:

2020-08-15 archivers/py-backports.lzma: Uses deprecated version of python
2020-08-15 archivers/py-bup: Uses deprecated version of python
2020-08-15 archivers/py-librtfcomp: Uses deprecated version of python
2020-08-15 audio/blop-lv2: Uses deprecated version of python
2020-08-15 audio/bs2b-lv2: Uses deprecated version of python
2020-08-15 audio/py-gmusicproxy: Uses deprecated version of python
2020-08-15 audio/py-karaoke: Uses deprecated version of python
2020-08-15 audio/py-openal: Uses deprecated version of python
2020-08-15 audio/py-py-jack: Uses deprecated version of python
2020-08-15 audio/py-xmms2: Uses deprecated version of python
2020-08-15 audio/triceratops-lv2: Uses deprecated version of python
2020-08-15 biology/py-biom-format: Uses deprecated version of python
2020-08-15 comms/py-bulksms: Uses deprecated version of python
(Only the first 15 lines of the commit message are shown above View all of this commit message)
2.5.1_7
01 Mar 2020 20:27:42
Revision:527601Original commit files touched by this commit
antoine search for other commits by this committer
Deprecate a few python 2.7 ports

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

Sponsored by:	Absolight
2.5.1_5
11 May 2018 07:27:12
Revision:469614Original commit files touched by this commit
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)
2.5.1_4
05 May 2018 10:49:36
Revision:469100Original commit files touched by this commit
antoine search for other commits by this committer
Deprecate ports broken for more than 6 months
2.5.1_4
02 Dec 2017 10:20:17
Revision:455341Original commit files touched by this commit Sanity Test Failure
antoine search for other commits by this committer
pyPgSQL doesn't build with python3
2.5.1_4
14 Oct 2017 16:31:35
Revision:452070Original commit files touched by this commit
bapt search for other commits by this committer
Mark as broken ports with invalid distfiles or no public distfiles
2.5.1_4
01 Apr 2016 14:00:57
Revision:412346Original commit files touched by this commit
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
2.5.1_4
17 Aug 2015 14:20:41
Revision:394508Original commit files touched by this commit
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
2.5.1_4
20 Oct 2014 10:41:13
Revision:371255Original commit files touched by this commit
bapt search for other commits by this committer
Cleanup plist
2.5.1_4
08 Oct 2014 17:16:34
Revision:370468Original commit files touched by this commit
bapt search for other commits by this committer
Convert to USES=pgsql and USES=python
2.5.1_4
10 Jun 2014 07:39:02
Revision:357277Original commit files touched by this commit
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)
2.5.1_4
24 Jan 2014 19:02:48
Revision:340923Original commit files touched by this commit
mva search for other commits by this committer
- Enable stagedir support
2.5.1_4
20 Sep 2013 16:13:49
Revision:327717Original commit files touched by this commit
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
2.5.1_4
08 Jan 2013 07:06:25
Revision:310073Original commit files touched by this commit
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)
2.5.1_4
22 Oct 2011 23:50:23
Original commit files touched by this commit
eadler search for other commits by this committer
- remove maintainer tags from pkg-descr

Approved by:    portmgr
Approved by:    bapt (mentor)
2.5.1_4
20 Mar 2011 12:54:45
Original commit files touched by this commit
miwi search for other commits by this committer
- Get Rid MD5 support
2.5.1_4
10 Sep 2010 04:18:06
Original commit files touched by this commit
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>
2.5.1_3
22 Aug 2009 00:18:43
Original commit files touched by this commit
amdmi3 search for other commits by this committer
- Switch SourceForge ports to the new File Release System: categories starting
with D
2.5.1_3
06 Jun 2008 13:17:10
Original commit files touched by this commit
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)
2.5.1_2
20 Jun 2007 21:24:22
Original commit files touched by this commit
lwhsu search for other commits by this committer
- EXAMPLES should be omitted when NOPORTEXAMPLES is defined

Noticed by:     sat
2.5.1_1
20 Jun 2007 15:57:27
Original commit files touched by this commit
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>
2.5.1
08 Jul 2006 05:29:20
Original commit files touched by this commit
rafan search for other commits by this committer
- Update to 2.5.1

Approved by:    delphij (mentor, implicit)
2.4_2
24 Nov 2005 01:23:57
Original commit files touched by this commit
pav search for other commits by this committer
- Add SHA256
2.4_2
05 Mar 2005 22:09:34
Original commit files touched by this commit
vs search for other commits by this committer
Reset maintainer on request. Thanks to Gerhard for maintaining the
ports so far!

PR:             ports/78088
2.4_2
31 Jan 2005 00:35:56
Original commit files touched by this commit
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)
2.4_1
31 Mar 2004 03:12:58
Original commit files touched by this commit
trevor search for other commits by this committer
SIZEify (maintainer timeout)
2.4_1
04 Feb 2004 05:21:48
Original commit files touched by this commit
marcus search for other commits by this committer
Bump PORTREVISION on all ports that depend on gettext to aid with upgrading.

(Part 2)
2.4
31 Jul 2003 06:50:03
Original commit files touched by this commit
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>
2.3
21 Feb 2003 11:15:05
Original commit files touched by this commit
knu search for other commits by this committer
De-pkg-comment.
2.3
04 Jan 2003 16:17:27
Original commit files touched by this commit
seanc search for other commits by this committer
Missed configure scripts in libpq version bump: chase lib version.
2.3
02 Jan 2003 19:28:46
Original commit files touched by this commit
ijliao search for other commits by this committer
upgrade to 2.3

PR:             46099
Submitted by:   maintainer
2.2
05 Oct 2002 23:12:29
Original commit files touched by this commit
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
2.2
16 Sep 2002 13:57:56
Original commit files touched by this commit
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
2.1
09 Jun 2002 16:06:47
Original commit files touched by this commit
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
2.0
29 Apr 2002 13:33:57
Original commit files touched by this commit
ijliao search for other commits by this committer
use USE_PYDISTUTILS
2.0
19 Mar 2002 18:27:05
Original commit files touched by this commit
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
commit hash: fp1.20687@dev.null.freshports.orgcommit hash: fp1.20687@dev.null.freshports.orgcommit hash: fp1.20687@dev.null.freshports.orgcommit hash: fp1.20687@dev.null.freshports.org 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
commit hash: fp1.20352@dev.null.freshports.orgcommit hash: fp1.20352@dev.null.freshports.orgcommit hash: fp1.20352@dev.null.freshports.orgcommit hash: fp1.20352@dev.null.freshports.org 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: 41