notbugIf you buy from Amazon USA, please support us by using this link.
Port details
py-postgresql Python 3 compatible PostgreSQL database driver and tools
1.1.0_4 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
Maintainer: c.kworr@gmail.com search for ports maintained by this maintainer
Port Added: 2009-12-18 19:23:01
Last Update: 2018-12-12 01:35:36
SVN Revision: 487272
Also Listed In: python
License: BSD3CLAUSE
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/
SVNWeb : Homepage

There is no configure plist information for this port.

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

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

PKGNAME: py36-postgresql

There is no flavor information for this port.

distinfo:

SHA256 (postgresql/py-postgresql-1.1.0.zip) = 4bae6e15bf0be03294240acc5b27f5aa2d9649188bc4528cd5b5512582e0ea93
SIZE (postgresql/py-postgresql-1.1.0.zip) = 254537


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
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
zip pgsql python:3.3+

Master Sites:
  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/
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: 15

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
12 Dec 2018 01:35:36
Original commit files touched by this commit  1.1.0_4
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
10 Jan 2015 23:15:28
Original commit files touched by this commit  1.1.0_3
Revision:376731
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  1.1.0_2
Revision:373539
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  1.1.0_1
Revision:370466
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  1.1.0_1
Revision:346881
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  1.1.0
Revision:340671
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  1.1.0
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)
10 Oct 2012 12:20:33
Original commit files touched by this commit  1.1.0
Revision:305647
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: 15

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
ocamlMay 23
firefoxMay 22
firefox-esrMay 22
libxulMay 22
linux-firefoxMay 22
linux-seamonkeyMay 22
linux-thunderbirdMay 22
seamonkeyMay 22
thunderbirdMay 22
waterfoxMay 22
rustMay 15
linux-flashplayerMay 14
samba46May 14
samba47May 14
samba48May 14

8 vulnerabilities affecting 120 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-05-23 20:44:01


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 36502
Broken 78
Deprecated 119
Ignore 297
Forbidden 3
Restricted 163
No CDROM 74
Vulnerable 33
Expired 34
Set to expire 92
Interactive 0
new 24 hours 9
new 48 hours12
new 7 days60
new fortnight99
new month190

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