Searches without login should now work. You must get asked to click a button.
Some translations wanted please.
New RSS 2.0 and Atom feeds are here. The old /backend/ feeds still work, but will be redirected later, so please update your subscriptions. Details.
Port details on branch 2026Q4
pgloader3 Data loading and migration tool for PostgreSQL using the COPY command
3.6.9_10 databases Σ=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 3.6.9_10Version of this port present on the latest quarterly branch.
Maintainer: freebsd-washroom@duhanic.com search for ports maintained by this maintainer
Port Added: 2026-10-26 01:15:09
Last Update: 2026-10-26 01:14:22
Commit Hash: 0a25f19
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.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port
Manual pages: #
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist #
Expand this list (4 items)
Collapse this list.
  1. bin/pgloader
  2. /usr/local/share/licenses/pgloader3-3.6.9_10/catalog.mk
  3. /usr/local/share/licenses/pgloader3-3.6.9_10/LICENSE
  4. /usr/local/share/licenses/pgloader3-3.6.9_10/PostgreSQL
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
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

Expand this list (142 items)

Collapse this list.

SHA256 (pgloader/anaphora-20220220-git.tgz) = f7114f9ea2f323f3c968e87c02930a4dac4d43b23069c1a7c5672929aa214e4a SIZE (pgloader/anaphora-20220220-git.tgz) = 6303 SHA256 (pgloader/asdf-finalizers-20221106-git.tgz) = 38720703e873e297a1c4c0ce8710a0c145b0c4a6c5ae38464d4c6f99f24545f1 SIZE (pgloader/asdf-finalizers-20221106-git.tgz) = 6608 SHA256 (pgloader/asdf-system-connections-20170124-git.tgz) = f8723e0b0b8bd5f964f7726536e52aacb2e9833d475fcde8333cda81d7190241 SIZE (pgloader/asdf-system-connections-20170124-git.tgz) = 4933 SHA256 (pgloader/babel-20230214-git.tgz) = 331a19e55f987aa0980014f3b5a9d2faea41c39912b87eab289408168b752ff9 SIZE (pgloader/babel-20230214-git.tgz) = 273967 SHA256 (pgloader/bordeaux-threads-v0.9.3.tgz) = a3f492e2f3b3155f1008e3737f70b4020ef75b82dbb00b5e39cf9a7fe7bd1ce6 SIZE (pgloader/bordeaux-threads-v0.9.3.tgz) = 3062902 SHA256 (pgloader/buildapp-1.5.6.tgz) = 53b8b94cf6d32eb367ac08c306283e37e46c1985fd9d1272b155c87e3c104e45 SIZE (pgloader/buildapp-1.5.6.tgz) = 16389 SHA256 (pgloader/cffi-20231021-git.tgz) = ab0d535950194bd6925ca5a28e461b571dd8d4c1bd714963d1e20fa06824bb9d SIZE (pgloader/cffi-20231021-git.tgz) = 263396 SHA256 (pgloader/chipz-20230618-git.tgz) = 7aac674e6a528fe65b67ca5538459a15f696237a0770b4ef7bf9239bf54f3ab8 SIZE (pgloader/chipz-20230618-git.tgz) = 37547 SHA256 (pgloader/chunga-20231021-git.tgz) = f6b52cab49bb4e22399059b1f9df75c2e9d9ac49442d08863ac735c70d5230b9 SIZE (pgloader/chunga-20231021-git.tgz) = 20929 SHA256 (pgloader/cl-base64-20201016-git.tgz) = 3ff50faf5ddccd409f8954eb70c2d4e76329cc916f070de95f79c7ecf6d3a2f1 SIZE (pgloader/cl-base64-20201016-git.tgz) = 10373 SHA256 (pgloader/cl-containers-20231021-git.tgz) = 7a64ae4a19bc869d54614fade6b52ca5f97c386ca08bc0ad91da6639bd40e798 SIZE (pgloader/cl-containers-20231021-git.tgz) = 231046 SHA256 (pgloader/cl-csv-20201016-git.tgz) = aefe992253555825b439871bf4b3a187569ab4375566e32b7bba6c23745322f0 SIZE (pgloader/cl-csv-20201016-git.tgz) = 25202 SHA256 (pgloader/cl-db3-20200218-git.tgz) = 4f3b47f37faddf70866aa6e4be234036eb64a32300c9670e4f66ad2f97b245f1 SIZE (pgloader/cl-db3-20200218-git.tgz) = 6162 SHA256 (pgloader/cl-fad-20220220-git.tgz) = 91faa900b70d369b8646d6d8b5b560d5fe10c10985132290278f8a9c094f4224 SIZE (pgloader/cl-fad-20220220-git.tgz) = 25285 SHA256 (pgloader/cl-interpol-20221106-git.tgz) = 534ef9a4048c86382b65fe195fe0bad1b18e169ee7e79980b40e52db4a2f96df SIZE (pgloader/cl-interpol-20221106-git.tgz) = 43666 SHA256 (pgloader/cl-ixf-20180228-git.tgz) = 7adba0bf221f6f91777457c9d6c52a0a7e034c628e18f09c7445ce50a8ff14fb SIZE (pgloader/cl-ixf-20180228-git.tgz) = 8677 SHA256 (pgloader/cl-log.1.0.1.tgz) = 4d7840b9e3bf5a979f780ba937f4e268c73db48e2f91f6c7c541d86e3ac0ab71 SIZE (pgloader/cl-log.1.0.1.tgz) = 18463 SHA256 (pgloader/cl-markdown-20191227-git.tgz) = 0d7187af7f42e8fb134d488e58050f865138d59c0aeeff5a2db825b5c1723b2d SIZE (pgloader/cl-markdown-20191227-git.tgz) = 73424 SHA256 (pgloader/cl-mssql-20210124-git.tgz) = 1802dfc0c762ec3cc95ea91eb30cf173a08fa90950b4b4c68a4ee727c7366c08 SIZE (pgloader/cl-mssql-20210124-git.tgz) = 15817 SHA256 (pgloader/cl-mustache-20200325-git.tgz) = 39abf474c26b61ea99d818a4ef95c48ab1bf7f2b630daf48af310d865fd539f4 SIZE (pgloader/cl-mustache-20200325-git.tgz) = 16325 SHA256 (pgloader/cl-ppcre-20230618-git.tgz) = aaba004bc82bf63886b8ce91eadaf0b78fd6c4865da09c3e66da7fbf2a127397 SIZE (pgloader/cl-ppcre-20230618-git.tgz) = 157428 SHA256 (pgloader/cl-sqlite-20190813-git.tgz) = b3e68114ead48de09b6042806ef05e8bed7eb7086e0ce9f5afef9d78a050f41f SIZE (pgloader/cl-sqlite-20190813-git.tgz) = 14632 SHA256 (pgloader/cl-unicode-20210228-git.tgz) = 5a16ef3ca0b37a840d55683c4c9acb8d68b511965bb8dc6343a79e752f2f1e5e SIZE (pgloader/cl-unicode-20210228-git.tgz) = 1290638 SHA256 (pgloader/cl-utilities-1.2.4.tgz) = 07a9318732d73b5195b1a442391d10395c7de471f1fe12feedfe71b1edbd51fc SIZE (pgloader/cl-utilities-1.2.4.tgz) = 22998 SHA256 (pgloader/cl+ssl-20231021-git.tgz) = 554e8cf79771221cf3991085da9b7cb659a78fd7ff71c81ae56d524f2d1eec46 SIZE (pgloader/cl+ssl-20231021-git.tgz) = 92364 SHA256 (pgloader/closer-mop-20231021-git.tgz) = bf454950450b592b75a41953171167efe0a047932dc292fb685941abecf458bb SIZE (pgloader/closer-mop-20231021-git.tgz) = 23805 SHA256 (pgloader/closure-common-20181018-git.tgz) = f6f60bdff5e6c2e41bbab98c44a3b4dedaa4f91047b9042ed330a9daad3c77a1 SIZE (pgloader/closure-common-20181018-git.tgz) = 27833 SHA256 (pgloader/command-line-arguments-20210807-git.tgz) = 939b3966e2887dd0b81bd1c3d051c42bce78c10fa32661263c9aa6c355fbf9bd SIZE (pgloader/command-line-arguments-20210807-git.tgz) = 12294 SHA256 (pgloader/cxml-20200610-git.tgz) = b8a2208af6c73d0ade9afec2a3b39a00f1d23e041a9195ac171d775709cc8514 SIZE (pgloader/cxml-20200610-git.tgz) = 155775 SHA256 (pgloader/drakma-v2.0.10.tgz) = 3beef18a3bfae7296418f46728ed8bd944b866f87fd23956a3de2c65a04828a3 SIZE (pgloader/drakma-v2.0.10.tgz) = 75317 SHA256 (pgloader/dynamic-classes-20231021-git.tgz) = 919b884303b540f37cd45fa9e52e0dd018d8e6f758321ac03ea75638b50a7d05 SIZE (pgloader/dynamic-classes-20231021-git.tgz) = 7217 SHA256 (pgloader/esrap-20230618-git.tgz) = 3eb28f3941719b0ef8ae524975bbb945da45e1666759fac3867f110cfa47740c SIZE (pgloader/esrap-20230618-git.tgz) = 69422 SHA256 (pgloader/flexi-streams-20220220-git.tgz) = a179543ed582f8920eb5363c1b3b48c45a3300f063d85601a5d668dfe8cfe706 SIZE (pgloader/flexi-streams-20220220-git.tgz) = 445922 SHA256 (pgloader/garbage-pools-20210124-git.tgz) = adb00cf419feb7dd625df71ffa1789573978fc11e67baa1e6fd4c21e5d15d7eb SIZE (pgloader/garbage-pools-20210124-git.tgz) = 45020 SHA256 (pgloader/global-vars-20141106-git.tgz) = f294843bb31144034e1370df1634dd74f24e617e3abb9c00c17927eda2ae4f2e SIZE (pgloader/global-vars-20141106-git.tgz) = 3581 SHA256 (pgloader/ieee-floats-20220220-git.tgz) = 6dd5d358fd1ea800f96a9a4b59895aa7b438a17e1c12e834e49605938c7b5145 SIZE (pgloader/ieee-floats-20220220-git.tgz) = 5274 SHA256 (pgloader/ironclad-v0.59.tgz) = e892031b86d38d86491fb5ae6b8b7495f10e0757d1d488e3a53507729b13fb0b SIZE (pgloader/ironclad-v0.59.tgz) = 1540441 SHA256 (pgloader/iterate-release-b0f9a9c6-git.tgz) = 9311c658a3950f7d5dd5d5aa4cebfe04f24b735c0560941be4b29f87550413bb SIZE (pgloader/iterate-release-b0f9a9c6-git.tgz) = 346126 SHA256 (pgloader/local-time-20231021-git.tgz) = cb50d778b6d54430ced7d02ad9e1918587207dbdf9df6cafbca8663ea9fd02cc SIZE (pgloader/local-time-20231021-git.tgz) = 743143 SHA256 (pgloader/lparallel-20160825-git.tgz) = 213bc89e6bbabe07fc3bcb21be1021b31f6f2ab1b7a2abb358a01ab9bee69c73 SIZE (pgloader/lparallel-20160825-git.tgz) = 78551 SHA256 (pgloader/md5-20210630-git.tgz) = 9bfde89ed7e0464204b66b9b9f6699d4234aeabe1d00695d711d993bf8a2719a SIZE (pgloader/md5-20210630-git.tgz) = 16719 SHA256 (pgloader/metabang-bind-20230618-git.tgz) = ff349506f5f201d13bf875358d1c69805427c7523d5a4b550162f768438f5281 SIZE (pgloader/metabang-bind-20230618-git.tgz) = 22657 SHA256 (pgloader/metatilities-base-20191227-git.tgz) = 347215567615e2139965d8b0f8f72e3c47bb65e3837226a950dece7a6e2854d5 SIZE (pgloader/metatilities-base-20191227-git.tgz) = 70648 SHA256 (pgloader/mgl-pax-20231021-git.tgz) = 81381da7306e859bf01ca706976a87919728353e861e2da5c0fc2c9af7db05e0 SIZE (pgloader/mgl-pax-20231021-git.tgz) = 981840 SHA256 (pgloader/named-readtables-20231021-git.tgz) = 1c6793586c521f98eaa8fa8e8ef48fbbaff97951c23ce4641393e5f4676d27d9 SIZE (pgloader/named-readtables-20231021-git.tgz) = 26739 SHA256 (pgloader/parse-number-v1.7.tgz) = 0a6a6b9a7a351306c4eae1ab1c3a8a0e2a88fafb8133124b9cb8de680a425186 SIZE (pgloader/parse-number-v1.7.tgz) = 5715 SHA256 (pgloader/postmodern-20231021-git.tgz) = 6eee682a8678a4bfa425b9183a3da692669efd98f079ec6d9172433666fc407f SIZE (pgloader/postmodern-20231021-git.tgz) = 590406 SHA256 (pgloader/puri-20201016-git.tgz) = fd3bd9acd2438eb89fcd0c8651b6f6b5d92f337872a8e59326a680666e7c079a SIZE (pgloader/puri-20201016-git.tgz) = 29178 SHA256 (pgloader/py-configparser-20170830-svn.tgz) = 325d2c059deaf3506f69ae7d8c71a0d5aa38a0f3f244a73a0b06676baa30c051 SIZE (pgloader/py-configparser-20170830-svn.tgz) = 8452 SHA256 (pgloader/qmynd-20190710-git.tgz) = e29f2d7edc55d0c262a3221d330daef38e5303851fb660ac0377804980e604c4 SIZE (pgloader/qmynd-20190710-git.tgz) = 48872 SHA256 (pgloader/quri-20230618-git.tgz) = d54ff38e28198f14a3779d4304e27f2fd8c27cfb7b6c53e0975c130b58214b82 SIZE (pgloader/quri-20230618-git.tgz) = 71813 SHA256 (pgloader/salza2-2.1.tgz) = 1da8fc6ee41372e0fbf2ac70af19f085bac68077dfb3bd3a77432525ea1abd7a SIZE (pgloader/salza2-2.1.tgz) = 17080 SHA256 (pgloader/split-sequence-v2.0.1.tgz) = ca47962ad1e2275e9c9092abedb392459c93b25b1f6f0565057e715bfa6dd274 SIZE (pgloader/split-sequence-v2.0.1.tgz) = 11705 SHA256 (pgloader/trivial-backtrace-20230214-git.tgz) = e34a3355ca15c2e0ed84160046c2b16680a7e8b164d67d5a049656786af6c84f SIZE (pgloader/trivial-backtrace-20230214-git.tgz) = 9368 SHA256 (pgloader/trivial-features-20230618-git.tgz) = 761c9c2fa75bec369e2aa9e2c42aea11889e40f168f1b5391a543a848c89171d SIZE (pgloader/trivial-features-20230618-git.tgz) = 11368 SHA256 (pgloader/trivial-garbage-20231021-git.tgz) = b29529bc3615ef373bcd8705b991709939dbcdf1071da494b1bf8e33c46d006a SIZE (pgloader/trivial-garbage-20231021-git.tgz) = 11005 SHA256 (pgloader/trivial-gray-streams-20231021-git.tgz) = 58c69d562c2c18fd385a6a78ad1ec43cdeb5fa8139e8a48710e7fc3e0926e695 SIZE (pgloader/trivial-gray-streams-20231021-git.tgz) = 8055 SHA256 (pgloader/trivial-utf-8-20231021-git.tgz) = a4be3897c9b34499f6f36741425dc894c43b2cb737513bdc738830cd7c153351 SIZE (pgloader/trivial-utf-8-20231021-git.tgz) = 6770 SHA256 (pgloader/trivial-with-current-source-form-20230618-git.tgz) = 127f5d0751611706865032f786e385fd4fd14f2ac443664da9b374c32cbf2df3 SIZE (pgloader/trivial-with-current-source-form-20230618-git.tgz) = 35295 SHA256 (pgloader/uax-15-20221106-git.tgz) = 8b76ca43a62639e1e6f9f1c235f0a72c9a719e8c3708d140ca0443b462ca5564 SIZE (pgloader/uax-15-20221106-git.tgz) = 834366 SHA256 (pgloader/usocket-0.8.6.tgz) = 33b94a7d3b2258bf6f06fbc52560dfbc3d2d8dd87ef407bfb18f10c40b17eb6e SIZE (pgloader/usocket-0.8.6.tgz) = 93803 SHA256 (pgloader/uuid-20200715-git.tgz) = a0e70fbfe72de65e06056197a206809108d1f5e2365fffd85a3b74f5a0c9b1fa SIZE (pgloader/uuid-20200715-git.tgz) = 22210 SHA256 (pgloader/yason-20230214-git.tgz) = 538090c1a656dbc447bfc988e004f44e0696d6223beacb8ed23b2d482f75dbc6 SIZE (pgloader/yason-20230214-git.tgz) = 31072 SHA256 (pgloader/zs3-1.3.3.tgz) = d6b5e2958f68957269147a1047e9a4f619d6e18be98e68021e2c8ef208fbccb5 SIZE (pgloader/zs3-1.3.3.tgz) = 57149 SHA256 (pgloader/dimitri-pgloader-v3.6.9_GH0.tar.gz) = 5639c580cd2c207947b6487316e901cb36291ea2be5bf1eb60cd6dba131aab3f SIZE (pgloader/dimitri-pgloader-v3.6.9_GH0.tar.gz) = 3722879 SHA256 (pgloader/quicklisp-quicklisp-bootstrap-version-2015-01-28_GH0.tar.gz) = 92aef100970de4e64b102be1f08de1c9a9e8f22d6711f6aad217ffb6d16fc82f SIZE (pgloader/quicklisp-quicklisp-bootstrap-version-2015-01-28_GH0.tar.gz) = 13942 SHA256 (pgloader/quicklisp-quicklisp-client-version-2021-02-13_GH0.tar.gz) = b0606eb7da7d98111430342a5cd6c7a3f7e2a86bdc4b0350e095d8dc06a995a2 SIZE (pgloader/quicklisp-quicklisp-client-version-2021-02-13_GH0.tar.gz) = 213744 SHA256 (pgloader/qitab-qmynd-7e56daf7_GH0.tar.gz) = 3b73f0e10e697cf4c76417935734a2a0abd9bdb53a6d893ba45f9b4c2fc1860d SIZE (pgloader/qitab-qmynd-7e56daf7_GH0.tar.gz) = 50195 SHA256 (pgloader/dimitri-cl-ixf-ed26f87e_GH0.tar.gz) = dcf377ff941302ac0535d05c617ca71a887e5f87b939c402b8ff6cd8b5e75a8e SIZE (pgloader/dimitri-cl-ixf-ed26f87e_GH0.tar.gz) = 8737 SHA256 (pgloader/dimitri-cl-db3-38e5ad35_GH0.tar.gz) = 09b7b5e49c4c96ce9920581ba3ead2f8578f1c69b71f427954047149f446cc01 SIZE (pgloader/dimitri-cl-db3-38e5ad35_GH0.tar.gz) = 6250 SHA256 (pgloader/AccelerationNet-cl-csv-68ecb5d8_GH0.tar.gz) = a3d17a2aed3dbe8106ff18e557c9e77ab823470b5d78fbe29fec9722135f4dd8 SIZE (pgloader/AccelerationNet-cl-csv-68ecb5d8_GH0.tar.gz) = 26245

Collapse this list.


Packages (timestamps in pop-ups are UTC): #
pgloader3
ABIaarch64amd64armv6armv7i386
FreeBSD:14:latest-3.6.9_10--3.6.9_10
FreeBSD:14:quarterly-3.6.9_10--3.6.9_10
FreeBSD:15:latest-3.6.9_10n/a-n/a
FreeBSD:15:quarterly-3.6.9_10n/a-n/a
FreeBSD:16:latest-3.6.9_10n/a-n/a
Dependencies #
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies: #
  1. sbcl : lang/sbcl
  2. gmake>=4.4.1 : devel/gmake
Library dependencies: #
  1. libsqlite3.so : databases/sqlite3
  2. libtdsodbc.so : databases/freetds
  3. libzstd.so : archivers/zstd
There are no ports dependent upon this port #

Configuration Options: #
No options to configure
Options name: #
databases_pgloader3
USES: #
gmake
pkg-message: #
FreshPorts was unable to extract/find any pkg message
Master Sites: #
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/dimitri/pgloader/tar.gz/v3.6.9?dummy=/
Collapse this list.

Number of commits found: 1 #

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
3.6.9_10
26 Oct 2026 01:14:22
commit hash: 0a25f19b849ba7b72eaf7adf449ed7c0610e332bcommit hash: 0a25f19b849ba7b72eaf7adf449ed7c0610e332bcommit hash: 0a25f19b849ba7b72eaf7adf449ed7c0610e332bcommit hash: 0a25f19b849ba7b72eaf7adf449ed7c0610e332b files touched by this commit
Vladimir Druzenko (vvd) search for other commits by this committer
Author: Michiel van Baak Jansen
databases/pgloader3: Fix crash during "reset sequences"

Column names that need to be quoted, will already be so quoting them
again results in sql errors.

Patch taken from:
https://github.com/codereverser/pgloader/commit/aba754a759f28701d94551e85c6b9c369e63698c
Upstreaming is of no use as upstream rewrote pgloader in java and is not
accepting patches for v3 anymore.

While at it:
- Replace PORTVERSION with DISTVERSION.
- Add libzstd to LIB_DEPENDS.
- Fix warnings from portclippy.
- Refresh patch.

PR:		298832
Approved by:	freebsd-washroom@duhanic.com (maintainer, timeout 1 month)
Sponsored by:	UNIS Labs (vvd)
Co-authored-by:	Vladimir Druzenko <vvd@FreeBSD.org>
MFH:		2026Q4

(cherry picked from commit 06a8a3bbb6302346f8fe2a8822286528f68fdf73)

Number of commits found: 1