Port details |
- pgloader Import CSV data and Large Object to PostgreSQL
- 2.3.1_5 databases
=0 2.3.1_5Version of this port present on the latest quarterly branch.
- DEPRECATED: Uses deprecated version of python
This port expired on: 2020-09-15
- Maintainer: pea@raveland.org
- Port Added: 2008-06-03 08:39:18
- Last Update: 2020-09-19 13:01:00
- SVN Revision: 548980
- License: not specified in port
- WWW:
- http://pgfoundry.org/projects/pgloader/
- Description:
- pgloader imports data from a flat file and inserts it into one or
more PostgreSQL database tables. It uses a flat file per database
table, and you can configure as many Sections as you want, each one
associating a table name and a data file.
Data are parsed and rewritten, then given to PostgreSQL COPY command.
Parsing is necessary for dealing with end of lines and eventual trailing
separator characters, and for column reordering: your flat data file may
not have the same column order as the database table has.
pgloader is also able to load some large objects data into PostgreSQL,
as of now only Informix UNLOAD data files are supported. This command
gives large objects data location information into the main data file.
pgloader parse it add the text or bytea content properly escaped to the
COPY data.
pgloader issues some timing statistics every "commit_every" commits. At
the end of processing each section, a summary of overall operations,
numbers of rows copied and commits, time it took in seconds, errors
logged and database errors is issued.
WWW: http://pgfoundry.org/projects/pgloader/
-
cgit ¦ GitHub ¦ GitHub ¦ GitLab ¦
- Manual pages:
-
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- pgloader>0:databases/pgloader
- No installation instructions:
- This port has been deleted.
- PKGNAME: pgloader
- Flavors: there is no flavor information for this port.
- distinfo:
- SHA256 (pgloader-2.3.1.tar.gz) = b3d9a1429c61083aa0030231bf938ab97c228ce90a9052330461d17a2058f73d
SIZE (pgloader-2.3.1.tar.gz) = 83071
No package information for this port in our database- Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link:
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- python2.7 : lang/python27
- Runtime dependencies:
-
- __init__.py : databases/py-psycopg2@py27
- python2.7 : lang/python27
- There are no ports dependent upon this port
Configuration Options:
- ===> The following configuration options are available for pgloader-2.3.1_5:
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:
- python:2.7 shebangfix
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
Commit | Credits | Log message |
2.3.1_5 19 Sep 2020 13:01:00 |
rene |
Remove expired ports:
2020-09-15 audio/abraca: Uses deprecated version of python
2020-09-15 audio/ardour5: Uses deprecated version of python
2020-09-15 audio/cplay: Uses deprecated version of python
2020-09-15 audio/cpp-xmms2: Uses deprecated version of python
2020-09-15 audio/p5-xmms2: Uses deprecated version of python
2020-09-15 biology/haplohseq: Uses deprecated version of python
2020-09-15 biology/tophat: Uses deprecated version of python
2020-09-15 chinese/ibus-array: Uses deprecated version of python
2020-09-15 comms/congruity: Uses deprecated version of python
2020-09-15 comms/libbtbb: Uses deprecated version of python
2020-09-15 comms/quisk: Uses deprecated version of python
2020-09-15 databases/mtools-mongodb: Uses deprecated version of python
2020-09-15 databases/mydbf2mysql: Uses deprecated version of python (Only the first 15 lines of the commit message are shown above ) |
2.3.1_5 08 Mar 2020 17:01:47 |
antoine |
Deprecate some ports using deprecated version of python
With hat: portmgr |
2.3.1_5 26 Jul 2019 20:46:57 |
gerald |
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.3.1_4 12 Dec 2018 01:35:36 |
gerald |
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.3.1_3 30 Nov 2017 15:50:34 |
mat |
Convert Python ports to FLAVORS.
Ports using USE_PYTHON=distutils are now flavored. They will
automatically get flavors (py27, py34, py35, py36) depending on what
versions they support.
There is also a USE_PYTHON=flavors for ports that do not use distutils
but need FLAVORS to be set. A USE_PYTHON=noflavors can be set if
using distutils but flavors are not wanted.
A new USE_PYTHON=optsuffix that will add PYTHON_PKGNAMESUFFIX has been
added to cope with Python ports that did not have the Python
PKGNAMEPREFIX but are flavored.
USES=python now also exports a PY_FLAVOR variable that contains the (Only the first 15 lines of the commit message are shown above ) |
2.3.1_3 22 Apr 2017 12:45:43 |
miwi |
- Fix shebangs |
2.3.1_2 23 May 2016 18:36:52 |
amdmi3 |
Convert tab after WWW: in pkg-descrs to single space as per PHB
Approved by: portmgr blanket |
2.3.1_2 19 May 2016 10:21:25 |
amdmi3 |
- Fix trailing whitespace in pkg-descrs, categories [a-f]*
Approved by: portmgr blanket |
2.3.1_2 01 Apr 2016 14:00:57 |
mat |
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.
With hat: portmgr
Sponsored by: Absolight |
2.3.1_2 20 Oct 2014 10:41:13 |
bapt |
Cleanup plist |
2.3.1_2 19 Oct 2014 08:50:18 |
mva |
- Convert ports from databases/ and deskutils/ to new USES=python
Approved by: portmgr (implicit) |
2.3.1_2 03 Jul 2014 21:48:44 |
adamw |
Nuke NOPORTDOCS. While, here, correct a couple offenders who label examples
with PORTDOCS. And, fix a couple WITH_foo invocations. |
2.3.1_2 19 May 2014 12:24:39 |
vanilla |
Support staging, sort pkg-plist.
Approved by: portmgr@ |
2.3.1_2 13 Jan 2014 21:00:04 |
rene |
Python cleanup:
- USE_PYTHON* = 2.X -> USE_PYTHON* = 2
- USE_PYTHON* = 2.X+ -> USE_PYTHON* = yes
Reviewed by: python (mva, rm)
Approved by: portmgr-lurkers (mat) |
2.3.1_2 20 Sep 2013 16:13:49 |
bapt |
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases) |
2.3.1_2 12 Feb 2012 15:31:34 |
rm |
- convert to using PYTHON_SITELIBDIR (not functional change) |
2.3.1_2 25 Feb 2011 00:12:12 |
miwi |
- Move over to py25+ or above
- While here kick md5 support |
2.3.1_1 06 Jun 2008 13:17:10 |
edwin |
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.3.1 05 Jun 2008 12:07:02 |
miwi |
- Update to 2.3.1
Submitted by: Pierre-Emmanuel André <pea@raveland.org> (maintainer via
private mail) |
2.3.0 03 Jun 2008 08:38:16 |
miwi |
pgloader imports data from a flat file and inserts it into one or
more PostgreSQL database tables. It uses a flat file per database
table, and you can configure as many Sections as you want, each one
associating a table name and a data file.
Data are parsed and rewritten, then given to PostgreSQL COPY command.
Parsing is necessary for dealing with end of lines and eventual trailing
separator characters, and for column reordering: your flat data file may
not have the same column order as the database table has.
pgloader is also able to load some large objects data into PostgreSQL,
as of now only Informix UNLOAD data files are supported. This command
gives large objects data location information into the main data file.
pgloader parse it add the text or bytea content properly escaped to the
COPY data.
pgloader issues some timing statistics every "commit_every" commits. At
the end of processing each section, a summary of overall operations,
numbers of rows copied and commits, time it took in seconds, errors
logged and database errors is issued.
WWW: http://pgfoundry.org/projects/pgloader/
PR: ports/124210
Submitted by: Pierre-Emmanuel Andre |