notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details on branch 2022Q3
pgloader3 Data loading and migration tool for PostgreSQL using the COPY command
3.6.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 View this port on Repology. pkg-fallout 3.6.3Version of this port present on the latest quarterly branch.
Maintainer: freebsd-washroom@duhanic.com search for ports maintained by this maintainer
Port Added: 2017-08-07 13:47:04
Last Update: 2022-09-07 21:58:51
Commit Hash: fb16dfe
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

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.3/catalog.mk
  3. /usr/local/share/licenses/pgloader3-3.6.3/LICENSE
  4. /usr/local/share/licenses/pgloader3-3.6.3/PostgreSQL
Collapse this list.
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 = 1646149110 SHA256 (pgloader/alexandria-20200925-git.tgz) = d425c4106dbdf879d900d5979189c6df675323bd13cd0c0f80ea00a4ddb7fbb2 SIZE (pgloader/alexandria-20200925-git.tgz) = 54730

Expand this list (132 items)

Collapse this list.

SHA256 (pgloader/anaphora-20210124-git.tgz) = 9b44816fc9a76f9293f9e1a714206a75ec94dcca59cd3e3173fa00b06de69d2c SIZE (pgloader/anaphora-20210124-git.tgz) = 6139 SHA256 (pgloader/asdf-finalizers-20170403-git.tgz) = b22f0fa44b662abdab5e844b03cd104f1c391234ad3d7bd4928bc521025053f0 SIZE (pgloader/asdf-finalizers-20170403-git.tgz) = 6663 SHA256 (pgloader/asdf-system-connections-20170124-git.tgz) = f8723e0b0b8bd5f964f7726536e52aacb2e9833d475fcde8333cda81d7190241 SIZE (pgloader/asdf-system-connections-20170124-git.tgz) = 4933 SHA256 (pgloader/babel-20200925-git.tgz) = d14984a29d7717a7a8b6c61b259eab20c615edf0a0c8ff6252f41f0eb9a8f2c2 SIZE (pgloader/babel-20200925-git.tgz) = 273336 SHA256 (pgloader/bordeaux-threads-v0.8.8.tgz) = f7026a580c6feb63dff7ac3882b7f1fda77dc2b9568208890cd3a493373debde SIZE (pgloader/bordeaux-threads-v0.8.8.tgz) = 23709 SHA256 (pgloader/buildapp-1.5.6.tgz) = 53b8b94cf6d32eb367ac08c306283e37e46c1985fd9d1272b155c87e3c104e45 SIZE (pgloader/buildapp-1.5.6.tgz) = 16389 SHA256 (pgloader/cffi_0.23.0.tgz) = 93759ebbf36752fee57883f870b76676fc57b9bdd4d135ef3a58ba52cb5bf7eb SIZE (pgloader/cffi_0.23.0.tgz) = 261680 SHA256 (pgloader/chipz-20190202-git.tgz) = aa58d80c12151f854b647b4d730ca29bba24c57f8954cb9ae777ee2968b568ee SIZE (pgloader/chipz-20190202-git.tgz) = 37110 SHA256 (pgloader/chunga-20200427-git.tgz) = 73ae124cd2c7703797b8df830fa79b757b3a97647909641ab351656395a5cd5c SIZE (pgloader/chunga-20200427-git.tgz) = 20599 SHA256 (pgloader/cl-abnf-20200325-git.tgz) = 8bfd6f1609bc15105f162781636a6ec76167471f44b4e0ada4990b3401b0074b SIZE (pgloader/cl-abnf-20200325-git.tgz) = 8343 SHA256 (pgloader/cl-base64-20201016-git.tgz) = 3ff50faf5ddccd409f8954eb70c2d4e76329cc916f070de95f79c7ecf6d3a2f1 SIZE (pgloader/cl-base64-20201016-git.tgz) = 10373 SHA256 (pgloader/cl-containers-20200427-git.tgz) = de81a2f1a916deb6193ec5dad08356624918381a5ae4873d870d684d6df58a52 SIZE (pgloader/cl-containers-20200427-git.tgz) = 231463 SHA256 (pgloader/cl-fad-20210124-git.tgz) = a0e649492be11799bdecea59a9a1eadd961beffb4a5bd18bb7fe72f2f8dc739f SIZE (pgloader/cl-fad-20210124-git.tgz) = 25201 SHA256 (pgloader/cl-interpol-20201220-git.tgz) = 6d34b69cf94d97de598f2c9a4ec8f5caa78c70c55a0644364520af4297ee7fe0 SIZE (pgloader/cl-interpol-20201220-git.tgz) = 43712 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-20190521-git.tgz) = 1d4b08ea962612ba92cec7c6f5bb0b8e82efddb91affa0007ada3a95dc66d25c SIZE (pgloader/cl-ppcre-20190521-git.tgz) = 155009 SHA256 (pgloader/cl-sqlite-20190813-git.tgz) = b3e68114ead48de09b6042806ef05e8bed7eb7086e0ce9f5afef9d78a050f41f SIZE (pgloader/cl-sqlite-20190813-git.tgz) = 14632 SHA256 (pgloader/cl-unicode-20210124-git.tgz) = 53f199070ddcc8dca0cf9f41c228a10202ea8a807973e80ecf4d34264e4b51a4 SIZE (pgloader/cl-unicode-20210124-git.tgz) = 1290624 SHA256 (pgloader/cl-utilities-1.2.4.tgz) = 07a9318732d73b5195b1a442391d10395c7de471f1fe12feedfe71b1edbd51fc SIZE (pgloader/cl-utilities-1.2.4.tgz) = 22998 SHA256 (pgloader/cl+ssl-20210124-git.tgz) = 6a1218a40059b2fbafcfd7c44a8bd5f2ff0011cb252548a537add649d4933ac1 SIZE (pgloader/cl+ssl-20210124-git.tgz) = 61870 SHA256 (pgloader/closer-mop-20210124-git.tgz) = fad37591fe34e1aadfad488bb2d8b0c6132e4604682fd49896577a54b70e8fcb SIZE (pgloader/closer-mop-20210124-git.tgz) = 23635 SHA256 (pgloader/closure-common-20181018-git.tgz) = f6f60bdff5e6c2e41bbab98c44a3b4dedaa4f91047b9042ed330a9daad3c77a1 SIZE (pgloader/closure-common-20181018-git.tgz) = 27833 SHA256 (pgloader/command-line-arguments-20200325-git.tgz) = 5f172efe084c94e10237c3442fa24410536fdd4fcdde305cbdd2d5c11560c05b SIZE (pgloader/command-line-arguments-20200325-git.tgz) = 11935 SHA256 (pgloader/cxml-20200610-git.tgz) = b8a2208af6c73d0ade9afec2a3b39a00f1d23e041a9195ac171d775709cc8514 SIZE (pgloader/cxml-20200610-git.tgz) = 155775 SHA256 (pgloader/drakma-v2.0.7.tgz) = fc4f54a4b21632ded510a58b420b5a61e6772ce2f2abe53d11d89dae2d801ae4 SIZE (pgloader/drakma-v2.0.7.tgz) = 74290 SHA256 (pgloader/dynamic-classes-20130128-git.tgz) = 4a93d3a39dca61c87b29877fa9707b647fc08f117f80f2a741f649e4d04c4b44 SIZE (pgloader/dynamic-classes-20130128-git.tgz) = 7148 SHA256 (pgloader/esrap-20211020-git.tgz) = f0f43009dc763ab41faa935db22ce2af183f825b4c1186ac12a8458da9da9819 SIZE (pgloader/esrap-20211020-git.tgz) = 69199 SHA256 (pgloader/flexi-streams-20200925-git.tgz) = 623d80b3a6a5ddfeec8365c940ddf2edba70ee85430f80767b645a399dcfbac2 SIZE (pgloader/flexi-streams-20200925-git.tgz) = 442184 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-20170830-git.tgz) = 137bc5b3385c35101a6440112757df46570395cdaeed4bf11648353638c18495 SIZE (pgloader/ieee-floats-20170830-git.tgz) = 5325 SHA256 (pgloader/ironclad-v0.54.tgz) = 829318fec0fe2ef850b1ccf6fc936a23fd8136dab3012b3a1ff631d4a5d5b706 SIZE (pgloader/ironclad-v0.54.tgz) = 1533878 SHA256 (pgloader/iterate-20200610-git.tgz) = cbd948acc37c638b4fc2af384d8415f9d60774766290a99e96efa315c4d8e377 SIZE (pgloader/iterate-20200610-git.tgz) = 332733 SHA256 (pgloader/local-time-20210124-git.tgz) = 7a3cf97b5e57494cdadb0c04c0be016866da6554544d7c9710cd3dd432f8e52f SIZE (pgloader/local-time-20210124-git.tgz) = 779489 SHA256 (pgloader/lparallel-20160825-git.tgz) = 213bc89e6bbabe07fc3bcb21be1021b31f6f2ab1b7a2abb358a01ab9bee69c73 SIZE (pgloader/lparallel-20160825-git.tgz) = 78551 SHA256 (pgloader/md5-20180228-git.tgz) = a4599d7733cfede17d3b47ab30eab330fb3781d2d3c83b17ea5eceba4c8fc188 SIZE (pgloader/md5-20180228-git.tgz) = 15847 SHA256 (pgloader/metabang-bind-20200218-git.tgz) = 1806db96b93b64450c7eb7665d606582c424a8fddf35caa14ad16cb4b5fbd255 SIZE (pgloader/metabang-bind-20200218-git.tgz) = 22543 SHA256 (pgloader/metatilities-base-20191227-git.tgz) = 347215567615e2139965d8b0f8f72e3c47bb65e3837226a950dece7a6e2854d5 SIZE (pgloader/metatilities-base-20191227-git.tgz) = 70648 SHA256 (pgloader/named-readtables-20210124-git.tgz) = 8436f51951747fc997f52ce3d752bfa718a88b9d39b835056e34ad86c3668b02 SIZE (pgloader/named-readtables-20210124-git.tgz) = 28291 SHA256 (pgloader/parse-number-v1.7.tgz) = 0a6a6b9a7a351306c4eae1ab1c3a8a0e2a88fafb8133124b9cb8de680a425186 SIZE (pgloader/parse-number-v1.7.tgz) = 5715 SHA256 (pgloader/postmodern-20210124-git.tgz) = 0c56af8aafda4831f60f9f8eb896d82ccb5af3dabd841bdc133816f5dc0081ba SIZE (pgloader/postmodern-20210124-git.tgz) = 556476 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/quri-20201220-git.tgz) = 298276fda2f0ce54a27b410b10c663bb5fdaa649c12943f8d2b9121a087c267b SIZE (pgloader/quri-20201220-git.tgz) = 69961 SHA256 (pgloader/split-sequence-v2.0.0.tgz) = 6aa973591b2ba75a07774638f4702cdf329c2aa668e3f7e9866a06fab9ae9525 SIZE (pgloader/split-sequence-v2.0.0.tgz) = 10329 SHA256 (pgloader/trivial-backtrace-20200610-git.tgz) = 7a665176bc3bd2f3e7d1c7888133498743182d2350d69f3a8e771baa20139f6a SIZE (pgloader/trivial-backtrace-20200610-git.tgz) = 9230 SHA256 (pgloader/trivial-features-20200715-git.tgz) = 22da592d1ae73e19b5b645ece4ca7af8d703cd99650565a42f38b27deeec1d40 SIZE (pgloader/trivial-features-20200715-git.tgz) = 11061 SHA256 (pgloader/trivial-garbage-20200925-git.tgz) = 034d308e463aebd4b0a86706d875416136490a45e978fec44a517e6c78143c02 SIZE (pgloader/trivial-garbage-20200925-git.tgz) = 10656 SHA256 (pgloader/trivial-gray-streams-20210124-git.tgz) = c68e05298ad46de2b48ac3c1d326617284f8701784d1623d4e4724620667986b SIZE (pgloader/trivial-gray-streams-20210124-git.tgz) = 8046 SHA256 (pgloader/trivial-utf-8-20200925-git.tgz) = 2bc4e6d9ab5abb527051cd1edac571d7b3a35b32afd1d364a1be17475c94691b SIZE (pgloader/trivial-utf-8-20200925-git.tgz) = 45210 SHA256 (pgloader/trivial-with-current-source-form-20200427-git.tgz) = 8e20dd22dcf5bf3873dc29d2c44642ec8349c8a3d33baecf833f1ce00491f317 SIZE (pgloader/trivial-with-current-source-form-20200427-git.tgz) = 46400 SHA256 (pgloader/uax-15-20210124-git.tgz) = a951e88c8f67ee0ce6b9e18c7fbd4d2cefd8aff88f79d508a0063a72fb023ffd SIZE (pgloader/uax-15-20210124-git.tgz) = 749207 SHA256 (pgloader/usocket-0.8.3.tgz) = a7d2d1cceea267da146310621c614dcf6226385f271efba946ba6299b238f4a5 SIZE (pgloader/usocket-0.8.3.tgz) = 85851 SHA256 (pgloader/uuid-20200715-git.tgz) = a0e70fbfe72de65e06056197a206809108d1f5e2365fffd85a3b74f5a0c9b1fa SIZE (pgloader/uuid-20200715-git.tgz) = 22210 SHA256 (pgloader/yason-v0.7.8.tgz) = c1193980a3588f163ecfd7810f221fbafa9fb8d1032e9ed5d5dd121e450ca585 SIZE (pgloader/yason-v0.7.8.tgz) = 27918 SHA256 (pgloader/zs3-1.3.3.tgz) = d6b5e2958f68957269147a1047e9a4f619d6e18be98e68021e2c8ef208fbccb5 SIZE (pgloader/zs3-1.3.3.tgz) = 57149 SHA256 (pgloader/dimitri-pgloader-v3.6.3_GH0.tar.gz) = 9dae3ebd29923f62967f734dc60599fafb451e778cd5e5e92f95ec229892bc4c SIZE (pgloader/dimitri-pgloader-v3.6.3_GH0.tar.gz) = 3718218 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
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest-3.6.3--3.6.3---
FreeBSD:13:quarterly-3.6.3--3.6.3---
FreeBSD:14:latest-3.6.3--3.6.3---
FreeBSD:14:quarterly-3.6.3--3.6.3---
FreeBSD:15:latest--n/a-n/a---
FreeBSD:15:quarterly--n/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.3 : devel/gmake
Library dependencies:
  1. libsqlite3.so : databases/sqlite3
  2. 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:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/dimitri/pgloader/tar.gz/v3.6.3?dummy=/
Collapse this list.

There are no commits on branch 2022Q3 for this port