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

Please give me your LTO-4 or better tape library and I'll put it to good use.
Port details
pgloader Import CSV data and Large Object to PostgreSQL
2.3.1_2 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: pea@raveland.org search for ports maintained by this maintainer
Port Added: 03 Jun 2008 08:39:18
License: not specified in port
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/
SVNWeb : Homepage : Distfiles Availability : PortsMon

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. python2.7 : lang/python27
Runtime dependencies:
  1. __init__.py : databases/py-psycopg2
  2. python2.7 : lang/python27
There are no ports dependent upon this port

To install the port: cd /usr/ports/databases/pgloader/ && make install clean
To add the package: pkg install databases/pgloader


Configuration Options
===> The following configuration options are available for pgloader-2.3.1_2:
     DOCS=on: Build and/or install documentation
     EXAMPLES=on: Build and/or install examples
===> Use 'make config' to modify these settings

USES:
python

Master Sites:
  1. http://distcache.FreeBSD.org/ports-distfiles/
  2. http://pgfoundry.org/frs/download.php/1814/

Number of commits found: 11

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
20 Oct 2014 10:41:13
Original commit files touched by this commit  2.3.1_2
Revision:371255
bapt search for other commits by this committer
Cleanup plist
19 Oct 2014 08:50:18
Original commit files touched by this commit  2.3.1_2
Revision:371173
mva search for other commits by this committer
- Convert ports from databases/ and deskutils/ to new USES=python

Approved by:	portmgr (implicit)
03 Jul 2014 21:48:44
Original commit files touched by this commit  2.3.1_2
Revision:360463  Sanity Test Failure
adamw search for other commits by this committer
Nuke NOPORTDOCS. While, here, correct a couple offenders who label examples
with PORTDOCS. And, fix a couple WITH_foo invocations.
19 May 2014 12:24:39
Original commit files touched by this commit  2.3.1_2
Revision:354530
vanilla search for other commits by this committer
Support staging, sort pkg-plist.

Approved by:	portmgr@
13 Jan 2014 21:00:04
Original commit files touched by this commit  2.3.1_2
Revision:339634
rene search for other commits by this committer
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)
20 Sep 2013 16:13:49
Original commit files touched by this commit  2.3.1_2
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)
12 Feb 2012 15:31:34
Original commit files touched by this commit  2.3.1_2
rm search for other commits by this committer
- convert to using PYTHON_SITELIBDIR (not functional change)
25 Feb 2011 00:12:12
Original commit files touched by this commit  2.3.1_2
  Sanity Test Failure
miwi search for other commits by this committer
- Move over to py25+ or above
- While here kick md5 support
06 Jun 2008 13:17:10
Original commit files touched by this commit  2.3.1_1
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)
05 Jun 2008 12:07:02
Original commit files touched by this commit  2.3.1
miwi search for other commits by this committer
- Update to 2.3.1

Submitted by:   Pierre-Emmanuel André <pea@raveland.org>  (maintainer via
private mail)
03 Jun 2008 08:38:16
Original commit files touched by this commit  2.3.0
miwi search for other commits by this committer
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

Number of commits found: 11

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
chicken*Jul 31
net-snmpJul 31
net-snmpJul 31
bind910Jul 28
bind99Jul 28
logstashJul 27
openssh-portableJul 27
chromiumJul 25
wordpress*Jul 24
wordpress*Jul 24
wordpress*Jul 24
wordpress*Jul 24
wordpress-zh_TW*Jul 24
libidnJul 23
opensaml2Jul 23

20 vulnerabilities affecting 50 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 25083
Broken 197
Deprecated 108
Ignore 498
Forbidden 1
Restricted 204
No CDROM 94
Vulnerable 44
Expired 3
Set to expire 96
Interactive 0
new 24 hours 1
new 48 hours1
new 7 days25
new fortnight60
new month169

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