BSD Portsdatabases/pgloader3 3.6.9_9 FreeBSD
Data loading and migration tool for PostgreSQL using the COPY command
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
e391b2e97c- License
- PostgreSQL
- Categories
- databases
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.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/pgloader3 | 3.6.9_9 |
| DragonFly | databases/pgloader3 | 3.6.3 |
Install
Binary package:
pkg install pgloader3From the ports tree:
cd /usr/ports/databases/pgloader3/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= pgloader3>0:databases/pgloader3Packages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | - | 3.6.9_9 | - | - | 3.6.9_9 |
| FreeBSD:14:quarterly | - | 3.6.9_9 | n/a | - | 3.6.9_9 |
| FreeBSD:15:latest | - | 3.6.9_9 | n/a | - | - |
| FreeBSD:15:quarterly | - | 3.6.9_9 | n/a | n/a | n/a |
| FreeBSD:16:latest | - | 3.6.9_9 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Build 1
sbcl: lang/sbcl
Library 2
libsqlite3.so: databases/sqlite3libtdsodbc.so: databases/freetds
The full lists below include those, and their dependencies in turn.
Build dependencies 18
Run dependencies 11
No port depends on this one.
Configuration
No options to configure.
- USES
- gmake
- Service scripts
- none
Files
distinfo 72
| File | Size | SHA256 |
|---|---|---|
| pgloader/alexandria-20231021-git.tgz | 57207 | 5bc0e459ebc303878e724f2ce082cc3bcfff94c4eb42621889e6e95c1a843d61 |
| pgloader/anaphora-20220220-git.tgz | 6303 | f7114f9ea2f323f3c968e87c02930a4dac4d43b23069c1a7c5672929aa214e4a |
| pgloader/asdf-finalizers-20221106-git.tgz | 6608 | 38720703e873e297a1c4c0ce8710a0c145b0c4a6c5ae38464d4c6f99f24545f1 |
| pgloader/asdf-system-connections-20170124-git.tgz | 4933 | f8723e0b0b8bd5f964f7726536e52aacb2e9833d475fcde8333cda81d7190241 |
| pgloader/babel-20230214-git.tgz | 273967 | 331a19e55f987aa0980014f3b5a9d2faea41c39912b87eab289408168b752ff9 |
| pgloader/bordeaux-threads-v0.9.3.tgz | 3.062902e+06 | a3f492e2f3b3155f1008e3737f70b4020ef75b82dbb00b5e39cf9a7fe7bd1ce6 |
| pgloader/buildapp-1.5.6.tgz | 16389 | 53b8b94cf6d32eb367ac08c306283e37e46c1985fd9d1272b155c87e3c104e45 |
| pgloader/cffi-20231021-git.tgz | 263396 | ab0d535950194bd6925ca5a28e461b571dd8d4c1bd714963d1e20fa06824bb9d |
| pgloader/chipz-20230618-git.tgz | 37547 | 7aac674e6a528fe65b67ca5538459a15f696237a0770b4ef7bf9239bf54f3ab8 |
| pgloader/chunga-20231021-git.tgz | 20929 | f6b52cab49bb4e22399059b1f9df75c2e9d9ac49442d08863ac735c70d5230b9 |
| pgloader/cl-base64-20201016-git.tgz | 10373 | 3ff50faf5ddccd409f8954eb70c2d4e76329cc916f070de95f79c7ecf6d3a2f1 |
| pgloader/cl-containers-20231021-git.tgz | 231046 | 7a64ae4a19bc869d54614fade6b52ca5f97c386ca08bc0ad91da6639bd40e798 |
| pgloader/cl-csv-20201016-git.tgz | 25202 | aefe992253555825b439871bf4b3a187569ab4375566e32b7bba6c23745322f0 |
| pgloader/cl-db3-20200218-git.tgz | 6162 | 4f3b47f37faddf70866aa6e4be234036eb64a32300c9670e4f66ad2f97b245f1 |
| pgloader/cl-fad-20220220-git.tgz | 25285 | 91faa900b70d369b8646d6d8b5b560d5fe10c10985132290278f8a9c094f4224 |
| pgloader/cl-interpol-20221106-git.tgz | 43666 | 534ef9a4048c86382b65fe195fe0bad1b18e169ee7e79980b40e52db4a2f96df |
| pgloader/cl-ixf-20180228-git.tgz | 8677 | 7adba0bf221f6f91777457c9d6c52a0a7e034c628e18f09c7445ce50a8ff14fb |
| pgloader/cl-log.1.0.1.tgz | 18463 | 4d7840b9e3bf5a979f780ba937f4e268c73db48e2f91f6c7c541d86e3ac0ab71 |
| pgloader/cl-markdown-20191227-git.tgz | 73424 | 0d7187af7f42e8fb134d488e58050f865138d59c0aeeff5a2db825b5c1723b2d |
| pgloader/cl-mssql-20210124-git.tgz | 15817 | 1802dfc0c762ec3cc95ea91eb30cf173a08fa90950b4b4c68a4ee727c7366c08 |
Master sites 65
- https://beta.quicklisp.org/archive/alexandria/2023-10-21/:alexandria
- https://beta.quicklisp.org/archive/anaphora/2022-02-20/:anaphora
- https://beta.quicklisp.org/archive/asdf-finalizers/2022-11-06/:asdffinalizers
- https://beta.quicklisp.org/archive/asdf-system-connections/2017-01-24/:asdfsystemconnections
- https://beta.quicklisp.org/archive/babel/2023-02-14/:babel
- https://beta.quicklisp.org/archive/bordeaux-threads/2023-10-21/:bordeauxthreads
- https://beta.quicklisp.org/archive/buildapp/2015-12-18/:buildapp
- https://beta.quicklisp.org/archive/cffi/2023-10-21/:cffi
- https://beta.quicklisp.org/archive/chipz/2023-06-18/:chipz
- https://beta.quicklisp.org/archive/chunga/2023-10-21/:chunga
- https://beta.quicklisp.org/archive/cl-base64/2020-10-16/:clbase64
- https://beta.quicklisp.org/archive/cl-containers/2023-10-21/:clcontainers
- https://beta.quicklisp.org/archive/cl-csv/2020-10-16/:clcsv
- https://beta.quicklisp.org/archive/cl-db3/2020-02-18/:cldb3
- https://beta.quicklisp.org/archive/cl-fad/2022-02-20/:clfad
- https://beta.quicklisp.org/archive/cl-interpol/2022-11-06/:clinterpol
- https://beta.quicklisp.org/archive/cl-ixf/2018-02-28/:clixf
- https://beta.quicklisp.org/archive/cl-log/2013-01-28/:cllog
- https://beta.quicklisp.org/archive/cl-markdown/2019-12-27/:clmarkdown
- https://beta.quicklisp.org/archive/cl-mssql/2021-01-24/:clmssql
- https://beta.quicklisp.org/archive/cl-mustache/2020-03-25/:clmustache
- https://beta.quicklisp.org/archive/cl-ppcre/2023-06-18/:clppcre
- https://beta.quicklisp.org/archive/cl-sqlite/2019-08-13/:clsqlite
- https://beta.quicklisp.org/archive/cl-unicode/2021-02-28/:clunicode
- https://beta.quicklisp.org/archive/cl-utilities/2010-10-06/:clutilities
- https://beta.quicklisp.org/archive/cl+ssl/2023-10-21/:clssl
- https://beta.quicklisp.org/archive/closer-mop/2023-10-21/:closermop
- https://beta.quicklisp.org/archive/closure-common/2018-10-18/:closurecommon
- https://beta.quicklisp.org/archive/command-line-arguments/2021-08-07/:commandlinearguments
- https://beta.quicklisp.org/archive/cxml/2020-06-10/:cxml
- https://beta.quicklisp.org/archive/drakma/2023-10-21/:drakma
- https://beta.quicklisp.org/archive/dynamic-classes/2023-10-21/:dynamicclasses
- https://beta.quicklisp.org/archive/esrap/2023-06-18/:esrap
- https://beta.quicklisp.org/archive/flexi-streams/2022-02-20/:flexistreams
- https://beta.quicklisp.org/archive/garbage-pools/2021-01-24/:garbagepools
- https://beta.quicklisp.org/archive/global-vars/2014-11-06/:globalvars
- https://beta.quicklisp.org/archive/ieee-floats/2022-02-20/:ieeefloats
- https://beta.quicklisp.org/archive/ironclad/2023-10-21/:ironclad
- https://beta.quicklisp.org/archive/iterate/2021-05-31/:iterate
- https://beta.quicklisp.org/archive/local-time/2023-10-21/:localtime
- https://beta.quicklisp.org/archive/lparallel/2016-08-25/:lparallel
- https://beta.quicklisp.org/archive/md5/2021-06-30/:md5
- https://beta.quicklisp.org/archive/metabang-bind/2023-06-18/:metabangbind
- https://beta.quicklisp.org/archive/metatilities-base/2019-12-27/:metatilitiesbase
- https://beta.quicklisp.org/archive/mgl-pax/2023-10-21/:mglpax
- https://beta.quicklisp.org/archive/named-readtables/2023-10-21/:namedreadtables
- https://beta.quicklisp.org/archive/parse-number/2018-02-28/:parsenumber
- https://beta.quicklisp.org/archive/postmodern/2023-10-21/:postmodern
- https://beta.quicklisp.org/archive/puri/2020-10-16/:puri
- https://beta.quicklisp.org/archive/py-configparser/2017-08-30/:pyconfigparser
- https://beta.quicklisp.org/archive/qmynd/2019-07-10/:qmynd
- https://beta.quicklisp.org/archive/quri/2023-06-18/:quri
- https://beta.quicklisp.org/archive/salza2/2021-10-20/:salza2
- https://beta.quicklisp.org/archive/split-sequence/2021-05-31/:splitsequence
- https://beta.quicklisp.org/archive/trivial-backtrace/2023-02-14/:trivialbacktrace
- https://beta.quicklisp.org/archive/trivial-features/2023-06-18/:trivialfeatures
- https://beta.quicklisp.org/archive/trivial-garbage/2023-10-21/:trivialgarbage
- https://beta.quicklisp.org/archive/trivial-gray-streams/2023-10-21/:trivialgraystreams
- https://beta.quicklisp.org/archive/trivial-utf-8/2023-10-21/:trivialutf8
- https://beta.quicklisp.org/archive/trivial-with-current-source-form/2023-06-18/:trivialwithcurrentsourceform
- https://beta.quicklisp.org/archive/uax-15/2022-11-06/:uax15
- https://beta.quicklisp.org/archive/usocket/2023-06-18/:usocket
- https://beta.quicklisp.org/archive/uuid/2020-07-15/:uuid
- https://beta.quicklisp.org/archive/yason/2023-02-14/:yason
- https://beta.quicklisp.org/archive/zs3/2019-10-07/:zs3