FreshPorts -- The Place For Ports notbugIf you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

Port details
py-postgresql Python 3 compatible PostgreSQL database driver and tools
1.1.0_3 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: 18 Dec 2009 19:23:01
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 : PortsMon
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (3 items)
  1. /usr/local/share/licenses/py36-postgresql-1.1.0_3/catalog.mk
  2. /usr/local/share/licenses/py36-postgresql-1.1.0_3/LICENSE
  3. /usr/local/share/licenses/py36-postgresql-1.1.0_3/BSD3CLAUSE
  4. Collapse this list.

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

PKGNAME: py36-postgresql

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/py36-setuptools
  2. python3.6 : lang/python36
Runtime dependencies:
  1. py36-setuptools>0 : devel/py36-setuptools
  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.python.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: 14

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
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: 14

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, 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
gitlabJan 17
transmission-daemonJan 14
xmltoolingJan 12
linux-flashplayerJan 09
awstatsJan 08
irssiJan 06
firefoxJan 05
waterfoxJan 05
libevhtp*Jan 04
oniguruma*Jan 04
php56-mbstring*Jan 04
php70-mbstring*Jan 04
php71-mbstring*Jan 04
irssi*Dec 31
roundcube*Dec 31

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

* - modified, not new

All vulnerabilities

Last updated:
2018-01-17 20:50:47


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 32608
Broken 130
Deprecated 92
Ignore 367
Forbidden 0
Restricted 172
No CDROM 77
Vulnerable 39
Expired 7
Set to expire 83
Interactive 0
new 24 hours 1
new 48 hours3
new 7 days735
new fortnight1497
new month3992

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