notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
py-postgresql Python 3 compatible PostgreSQL database driver and tools
1.1.0_5 databases on this many watch lists=0 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 1.1.0_5Version of this port present on the latest quarterly branch.
Maintainer: c.kworr@gmail.com search for ports maintained by this maintainer
Port Added: 2009-12-18 19:23:01
Last Update: 2021-04-07 08:09:01
Commit Hash: cf118cc
Also Listed In: python
License: BSD3CLAUSE
Description:
SVNWeb : git : Homepage
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}postgresql>0:databases/py-postgresql@${PY_FLAVOR}
To install the port: cd /usr/ports/databases/py-postgresql/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-postgresql
  • pkg install py37-postgresql
NOTE: This is a Python port. Instead of py37-postgresql listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py37-postgresql
Package flavors (<flavor>: <package>)
  • py37: py37-postgresql
distinfo:
Packages (timestamps in pop-ups are UTC):
py34-postgresql
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd64--
FreeBSD:11:armv61.1.0_3-
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips641.1.0_3-
FreeBSD:12:aarch64--
FreeBSD:12:amd64--
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips64--
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--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py36-postgresql
ABIlatestquarterly
FreeBSD:11:aarch641.1.0_3-
FreeBSD:11:amd64--
FreeBSD:11:armv6--
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch641.1.0_3-
FreeBSD:12:amd64--
FreeBSD:12:armv61.1.0_3-
FreeBSD:12:armv71.1.0_3-
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips641.1.0_3-
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--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py37-postgresql
ABIlatestquarterly
FreeBSD:11:aarch64-1.1.0_5
FreeBSD:11:amd64--
FreeBSD:11:armv6-1.1.0_5
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64-1.1.0_5
FreeBSD:12:aarch64--
FreeBSD:12:amd64--
FreeBSD:12:armv6-1.1.0_5
FreeBSD:12:armv7-1.1.0_5
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips64-1.1.0_5
FreeBSD:12:powerpc64-1.1.0_5
FreeBSD:13:aarch641.1.0_5-
FreeBSD:13:amd64--
FreeBSD:13:armv61.1.0_51.1.0_5
FreeBSD:13:armv71.1.0_51.1.0_5
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc641.1.0_5-
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv61.1.0_5-
FreeBSD:14:armv71.1.0_5-
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc641.1.0_5-
 
py38-postgresql
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd641.1.0_51.1.0_5
FreeBSD:11:armv6--
FreeBSD:11:i3861.1.0_51.1.0_5
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch64-1.1.0_5
FreeBSD:12:amd641.1.0_51.1.0_5
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i3861.1.0_51.1.0_5
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64-1.1.0_5
FreeBSD:13:amd641.1.0_51.1.0_5
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i3861.1.0_51.1.0_5
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64-1.1.0_5
FreeBSD:14:aarch641.1.0_5-
FreeBSD:14:amd641.1.0_5-
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i3861.1.0_5-
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 

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-setuptools>0 : devel/py-setuptools@py37
  2. python3.7 : lang/python37
Library dependencies:
  1. libpq.so.5 : databases/postgresql12-client
There are no ports dependent upon this port

Configuration Options:
Options name:

USES:

Master Sites:
Expand this list (3 items)
Collapse this list.
  1. http://python.projects.postgresql.org/files/
  2. https://files.pythonhosted.org/packages/source/p/py-postgresql/
  3. https://pypi.org/packages/source/p/py-postgresql/
Collapse this list.

Number of commits found: 18

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
07 Apr 2021 08:09:01
 files touched by this commit commit hash:cf118ccf875508b9a1c570044c93cfcc82bd455c  1.1.0_5
mat search for other commits by this committer
One more small cleanup, forgotten yesterday.
Reported by:	lwhsu
06 Apr 2021 14:31:07
 files touched by this commit commit hash:305f148f482daf30dcf728039d03d019f88344eb  1.1.0_5
mat search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
26 Jul 2019 20:46:57
Original commit files touched by this commit Revision:507372  1.1.0_5
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 Revision:487272  1.1.0_4
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
10 Jan 2015 23:15:28
Original commit files touched by this commit Revision:376731  1.1.0_3
demon search for other commits by this committer
Switch default python3 version from 3.3 to 3.4.
Bump PORTREVISIONs for the affected ports.

Exp-run by:	antoine
28 Nov 2014 10:02:20
Original commit files touched by this commit Revision:373539  1.1.0_2
marino search for other commits by this committer
databases/py-postgresql: Support python 3.4

When python 3 only is specified, building the port tries to install
python 3.3 even if python 3.4 is requested, so this change addresses that.

PR:		194656
Submitted by:	Axel Rau (chaos1.de)
Approved by:	maintainer timeout
08 Oct 2014 17:14:52
Original commit files touched by this commit Revision:370466  1.1.0_1
bapt search for other commits by this committer
Convert USES=pgsql and USES=python:3
07 Mar 2014 16:49:10
Refresh Original commit files touched by this commit Revision:347405  Sanity Test Failure
bapt search for other commits by this committer
Convert d* to USES=zip
03 Mar 2014 11:09:52
Original commit files touched by this commit Revision:346881  1.1.0_1
rm search for other commits by this committer
databases/py-postgresql: remove local plist hack and support staging

- clarify the license (BSD3C)
- use 3 in USE_PYTHON
- convert to using auto-generated packing list and remove NO_STAGE
- remove local plist hack - it is now handled by bsd.python.mk
- bump PORTREVISION for the case

Approved by:	portmgr (blanket)
21 Jan 2014 23:18:05
Original commit files touched by this commit Revision:340671  1.1.0
bapt search for other commits by this committer
Fix properties on pkg-plist
20 Sep 2013 16:13:49
Original commit files touched by this commit Revision:327717  1.1.0
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
10 Oct 2012 12:20:33
Original commit files touched by this commit Revision:305647  1.1.0
rm search for other commits by this committer
- update to 1.1.0
- trim Makefile header completely (requested by maintainer)
- add CHEESESHOP and make it primary MASTER_SITE, because other locations
  doesn't hold the new release yet
- remove one distfile mirror (requested by maintainer)
- add LICENSE (BSD)
- replace USE_XZ with USE_ZIP, since it was changed upstream
- tune PYDISTUTILS_PKGNAME
- move python32 plist stuff into separate file

changelog:
http://pgfoundry.org/pipermail/python-general/2012-October/001003.html

PR:		172544 (but I can't see it in GNATS because of hub transition)
Submitted by:	rm (myself)
Approved by:	Volodymyr Kostyrko <c.kworr at gmail dot com> (maintainer, by mail)
09 Jul 2012 20:13:29
Original commit files touched by this commit   1.0.4
nivit search for other commits by this committer
- Update to 1.0.4  [1]
- Fix pkg-plist when Python version >= 3.2
  (solution approved by maintainer via private email)

PR:             ports/167569
Submitted by:   William Grzybowski <william88 at gmail.com>
Approved by:    Volodymyr Kostyrko <c.kworr at gmail.com> (maintainer)
20 Mar 2011 12:54:45
Original commit files touched by this commit   1.0.2
miwi search for other commits by this committer
- Get Rid MD5 support
06 Oct 2010 01:42:41
Original commit files touched by this commit   1.0.2
sunpoet search for other commits by this committer
- Update to 1.0.2

PR:             ports/150773
Submitted by:   Volodymyr Kostyrko <c.kworr at gmail.com> (maintainer)
Approved by:    pgollucci (mentor)
04 Jul 2010 19:40:02
Original commit files touched by this commit   1.0.1
jpaetzel search for other commits by this committer
Update to version 1.0.1

PR:     ports/148148
Submitted by:   Volodymyr Kostyrko <c.kworr@gmail.com>
Approved by:    itetcu@ (mentor) implicit
Feature safe: yes
31 Jan 2010 06:37:30
Original commit files touched by this commit   0.9.3
lwhsu search for other commits by this committer
- Update to 0.9.3

PR:             ports/142473
Submitted by:   Volodymyr Kostyrko <c.kworr AT gmail.com> (maintainer)
18 Dec 2009 19:22:02
Original commit files touched by this commit   0.9.1
pav search for other commits by this committer
Pure Python
All code, at first, is written in pure Python so that py-postgresql will work
anywhere that you can install Python 3. Optimizations in C are made where
needed, but are always optional.

Prepared Statements
Using the PG-API interface, protocol-level prepared statements may be created
and used multiple times. db.prepare(sql)(*args)

COPY Support
Use the convenient COPY interface to directly copy data from one connection to
another. No intermediate files or tricks are necessary.

Arrays and Composite Typescw
Arrays and composites are fully supported. Queries requesting them will returns
objects that provide access to the elements within.

"pg_python" Quick Console
Get a Python console with a connection to PostgreSQL for quick tests and simple
scripts.

WWW: http://python.projects.postgresql.org/

PR:             ports/137782
Submitted by:   Volodymyr Kostyrko <c.kworr@gmail.com>

Number of commits found: 18