| Port details |
- pgloader3 Data loading and migration tool for PostgreSQL using the COPY command
- 3.6.9 databases
 =2      3.6.3Version of this port present on the latest quarterly branch. - Maintainer: freebsd-washroom@duhanic.com
- Port Added: 2017-08-07 13:47:04
- Last Update: 2025-04-12 23:53:40
- Commit Hash: f23ac50
- People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
- License: PostgreSQL
- WWW:
- https://pgloader.io
- Description:
- pgloader loads data from various sources into PostgreSQL. It can transform the
data it reads on the fly and submit raw SQL before and after the loading.
It uses the COPY PostgreSQL protocol to stream the data into the server,
and manages errors by filling a pair of reject.dat and reject.log files.
Thanks to being able to load data directly from a database source, pgloader
also supports migrations from other productions to PostgreSQL. In this mode of
operation, pgloader handles both the schema and data parts of the migration in a
single unmanned command, allowing to implement Continuous Migration.
  ¦  ¦  ¦  ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- pgloader3>0:databases/pgloader3
- To install the port:
- cd /usr/ports/databases/pgloader3/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/pgloader3
- pkg install pgloader3
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: pgloader3
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1724064210
SHA256 (pgloader/alexandria-20231021-git.tgz) = 5bc0e459ebc303878e724f2ce082cc3bcfff94c4eb42621889e6e95c1a843d61
SIZE (pgloader/alexandria-20231021-git.tgz) = 57207
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- sbcl : lang/sbcl
- gmake>=4.4.1 : devel/gmake
- Library dependencies:
-
- libsqlite3.so : databases/sqlite3
- libtdsodbc.so : databases/freetds
- There are no ports dependent upon this port
Configuration Options:- No options to configure
- Options name:
- databases_pgloader3
- USES:
- gmake
- 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 |
|---|
3.6.9
12 Apr 2025 23:53:40
 |
Mark Felder (feld) |
databases/pgloader3: Update to 3.6.9
Submitted by: fax@nohik.ee
PR: 270022 |
07 Sep 2022 21:58:51
|
Stefan Eßer (se) |
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner) |
3.6.3
07 Sep 2022 21:10:59
|
Stefan Eßer (se) |
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above  ) |
3.6.3
20 Apr 2022 11:26:13
|
Christoph Moench-Tegeder (cmt) |
databases/pgloader3: update to 3.6.3
https://github.com/dimitri/pgloader/releases/tag/v3.6.3
PR: 263100
Approved by: maintainer-timeout |
3.6.2_1
01 Feb 2022 18:39:20
|
Christoph Moench-Tegeder (cmt) |
databases/pgloader3: update esrap package to 2021-10-20
the older esrap package cannot be built with a recent sbcl compiler,
thus rendering pgloader3 unbuildable. this update bumps esrap to
a recent version which is compatible with our current sbcl compiler.
PR: 261319
Approved by: maintainer-timeout |
3.6.2
07 Apr 2021 08:09:01
|
Mathieu Arnold (mat) |
One more small cleanup, forgotten yesterday.
Reported by: lwhsu |
3.6.2
06 Apr 2021 14:31:07
|
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
3.6.2
24 Feb 2021 21:43:00
 |
cmt |
allow pgloader3 to build on 32bit platforms
guess if we're on a 32bit platform and set a reduced DYNSIZE - else
sbcl may hit it's adress space limits.
PR: 253766
Submitted by: maintainer |
3.6.2
20 Feb 2021 20:46:08
|
cmt |
pgloader3: unbreak and update to 3.6.2
submitter becomes maintainer
PR: 252716
Submitted by: Mario Duhanic |
3.4.1
30 Sep 2020 09:48:11
|
antoine |
Mark BROKEN
Fatal CIRCULAR-DEPENDENCY:
Circular dependency: ((#<LOAD-OP> . #<SYSTEM "simple-date">) (#<LOAD-OP> .
#<SYSTEM "simple-date-postgres-glue">) (#<LOAD-OP> . #<MODULE
"simple-date-postgres-glue" "simple-date">) (#<LOAD-OP> . #<CL-SOURCE-FILE
"simple-date-postgres-glue" "simple-date" "cl-postgres-glue">) (#<PREPARE-OP> .
#<CL-SOURCE-FILE "simple-date-postgres-glue" "simple-date" "cl-postgres-glue">)
(#<PREPARE-OP> . #<MODULE "simple-date-postgres-glue" "simple-date">)
(#<PREPARE-OP> . #<SYSTEM "simple-date-postgres-glue">))
Fatal error in "buildapp" : Error #<SILENT-EXIT-ERROR #x3020005BBF5D>
Reported by: pkg-fallout |
3.4.1
22 Jun 2018 08:28:00
|
yuri |
Correction to r473019: Revert the unintended change to the 'Created by' headers. |
3.4.1
22 Jun 2018 08:04:39
|
yuri |
Reset MAINTAINER on ports maintained by amutu@amutu.com
Based on the new policy of all maintained ports reset
when maintaner is absent for 3 months.
Bug#226400 for science/py-tensorflow is ignored since 2018-03-06 (3+ months).
portscout database indicates that 48.94% of his ports aren't updated. |
3.4.1
07 Aug 2017 13:46:50
|
tz |
New port: databases/pgloader3
Pgloader loads data into PostgreSQL using the COPY streaming protocol,and
doing so with separate threads for reading and writing data.Asynchronous
IO,compiled to the metal programming language.
pgloader knows how to read data from MySQL,SQLite or dBase databases,and
knows how to discover the schema and properly cast data types over.It also
knows how to read CSV files in several definitions of CSV,and fixed columns
files.
WWW: http://pgloader.io
PR: 219165
Submitted by: Jov <amutu@amutu.com> |
As an Amazon Associate I earn from qualifying purchases.