5 files changed, 369 insertions, 67 deletions

diff --git a/databases/pgloader3/Makefile b/databases/pgloader3/Makefile
index 8a501b5b8233..316b5310dc42 100644
--- a/databases/pgloader3/Makefile
+++ b/databases/pgloader3/Makefile
@@ -1,47 +1,235 @@
-# Created by: Jov <amutu@amutu.com>
 # $FreeBSD$
 
 PORTNAME=	pgloader
-PORTVERSION=	3.4.1
+PORTVERSION=	3.6.2
 DISTVERSIONPREFIX=	v
 CATEGORIES=	databases
+MASTER_SITES=	https://beta.quicklisp.org/archive/alexandria/2020-09-25/:alexandria \
+		https://beta.quicklisp.org/archive/anaphora/2021-01-24/:anaphora \
+		https://beta.quicklisp.org/archive/asdf-finalizers/2017-04-03/:asdffinalizers \
+		https://beta.quicklisp.org/archive/asdf-system-connections/2017-01-24/:asdfsystemconnections \
+		https://beta.quicklisp.org/archive/babel/2020-09-25/:babel \
+		https://beta.quicklisp.org/archive/bordeaux-threads/2020-06-10/:bordeauxthreads \
+		https://beta.quicklisp.org/archive/buildapp/2015-12-18/:buildapp \
+		https://beta.quicklisp.org/archive/cffi/2020-07-15/:cffi \
+		https://beta.quicklisp.org/archive/chipz/2019-02-02/:chipz \
+		https://beta.quicklisp.org/archive/chunga/2020-04-27/:chunga \
+		https://beta.quicklisp.org/archive/cl-abnf/2020-03-25/:clabnf \
+		https://beta.quicklisp.org/archive/cl-base64/2020-10-16/:clbase64 \
+		https://beta.quicklisp.org/archive/cl-containers/2020-04-27/:clcontainers \
+		https://beta.quicklisp.org/archive/cl-fad/2021-01-24/:clfad \
+		https://beta.quicklisp.org/archive/cl-interpol/2020-12-20/:clinterpol \
+		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/2019-05-21/:clppcre \
+		https://beta.quicklisp.org/archive/cl-sqlite/2019-08-13/:clsqlite \
+		https://beta.quicklisp.org/archive/cl-unicode/2021-01-24/:clunicode \
+		https://beta.quicklisp.org/archive/cl-utilities/2010-10-06/:clutilities \
+		https://beta.quicklisp.org/archive/cl+ssl/2021-01-24/:clssl \
+		https://beta.quicklisp.org/archive/closer-mop/2021-01-24/:closermop \
+		https://beta.quicklisp.org/archive/closure-common/2018-10-18/:closurecommon \
+		https://beta.quicklisp.org/archive/command-line-arguments/2020-03-25/:commandlinearguments \
+		https://beta.quicklisp.org/archive/cxml/2020-06-10/:cxml \
+		https://beta.quicklisp.org/archive/drakma/2019-11-30/:drakma \
+		https://beta.quicklisp.org/archive/dynamic-classes/2013-01-28/:dynamicclasses \
+		https://beta.quicklisp.org/archive/esrap/2020-12-20/:esrap \
+		https://beta.quicklisp.org/archive/flexi-streams/2020-09-25/: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/2017-08-30/:ieeefloats \
+		https://beta.quicklisp.org/archive/ironclad/2021-01-24/:ironclad \
+		https://beta.quicklisp.org/archive/iterate/2020-06-10/:iterate \
+		https://beta.quicklisp.org/archive/local-time/2021-01-24/:localtime \
+		https://beta.quicklisp.org/archive/lparallel/2016-08-25/:lparallel \
+		https://beta.quicklisp.org/archive/md5/2018-02-28/:md5 \
+		https://beta.quicklisp.org/archive/metabang-bind/2020-02-18/:metabangbind \
+		https://beta.quicklisp.org/archive/metatilities-base/2019-12-27/:metatilitiesbase \
+		https://beta.quicklisp.org/archive/named-readtables/2021-01-24/:namedreadtables \
+		https://beta.quicklisp.org/archive/parse-number/2018-02-28/:parsenumber \
+		https://beta.quicklisp.org/archive/postmodern/2021-01-24/: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/quri/2020-12-20/:quri \
+		https://beta.quicklisp.org/archive/split-sequence/2019-05-21/:splitsequence \
+		https://beta.quicklisp.org/archive/trivial-backtrace/2020-06-10/:trivialbacktrace \
+		https://beta.quicklisp.org/archive/trivial-features/2020-07-15/:trivialfeatures \
+		https://beta.quicklisp.org/archive/trivial-garbage/2020-09-25/:trivialgarbage \
+		https://beta.quicklisp.org/archive/trivial-gray-streams/2021-01-24/:trivialgraystreams \
+		https://beta.quicklisp.org/archive/trivial-utf-8/2020-09-25/:trivialutf8 \
+		https://beta.quicklisp.org/archive/trivial-with-current-source-form/2020-04-27/:trivialwithcurrentsourceform \
+		https://beta.quicklisp.org/archive/uax-15/2021-01-24/:uax15 \
+		https://beta.quicklisp.org/archive/usocket/2019-12-27/:usocket \
+		https://beta.quicklisp.org/archive/uuid/2020-07-15/:uuid \
+		https://beta.quicklisp.org/archive/yason/2019-12-27/:yason \
+		https://beta.quicklisp.org/archive/zs3/2019-10-07/:zs3
 PKGNAMESUFFIX=	3
+DISTFILES=	alexandria-20200925-git.tgz:alexandria \
+		anaphora-20210124-git.tgz:anaphora \
+		asdf-finalizers-20170403-git.tgz:asdffinalizers \
+		asdf-system-connections-20170124-git.tgz:asdfsystemconnections \
+		babel-20200925-git.tgz:babel \
+		bordeaux-threads-v0.8.8.tgz:bordeauxthreads \
+		buildapp-1.5.6.tgz:buildapp \
+		cffi_0.23.0.tgz:cffi \
+		chipz-20190202-git.tgz:chipz \
+		chunga-20200427-git.tgz:chunga \
+		cl-abnf-20200325-git.tgz:clabnf \
+		cl-base64-20201016-git.tgz:clbase64 \
+		cl-containers-20200427-git.tgz:clcontainers \
+		cl-fad-20210124-git.tgz:clfad \
+		cl-interpol-20201220-git.tgz:clinterpol \
+		cl-log.1.0.1.tgz:cllog \
+		cl-markdown-20191227-git.tgz:clmarkdown \
+		cl-mssql-20210124-git.tgz:clmssql \
+		cl-mustache-20200325-git.tgz:clmustache \
+		cl-ppcre-20190521-git.tgz:clppcre \
+		cl-sqlite-20190813-git.tgz:clsqlite \
+		cl-unicode-20210124-git.tgz:clunicode \
+		cl-utilities-1.2.4.tgz:clutilities \
+		cl+ssl-20210124-git.tgz:clssl \
+		closer-mop-20210124-git.tgz:closermop \
+		closure-common-20181018-git.tgz:closurecommon \
+		command-line-arguments-20200325-git.tgz:commandlinearguments \
+		cxml-20200610-git.tgz:cxml \
+		drakma-v2.0.7.tgz:drakma \
+		dynamic-classes-20130128-git.tgz:dynamicclasses \
+		esrap-20201220-git.tgz:esrap \
+		flexi-streams-20200925-git.tgz:flexistreams \
+		garbage-pools-20210124-git.tgz:garbagepools \
+		global-vars-20141106-git.tgz:globalvars \
+		ieee-floats-20170830-git.tgz:ieeefloats \
+		ironclad-v0.54.tgz:ironclad \
+		iterate-20200610-git.tgz:iterate \
+		local-time-20210124-git.tgz:localtime \
+		lparallel-20160825-git.tgz:lparallel \
+		md5-20180228-git.tgz:md5 \
+		metabang-bind-20200218-git.tgz:metabangbind \
+		metatilities-base-20191227-git.tgz:metatilitiesbase \
+		named-readtables-20210124-git.tgz:namedreadtables \
+		parse-number-v1.7.tgz:parsenumber \
+		postmodern-20210124-git.tgz:postmodern \
+		puri-20201016-git.tgz:puri \
+		py-configparser-20170830-svn.tgz:pyconfigparser \
+		quri-20201220-git.tgz:quri \
+		split-sequence-v2.0.0.tgz:splitsequence \
+		trivial-backtrace-20200610-git.tgz:trivialbacktrace \
+		trivial-features-20200715-git.tgz:trivialfeatures \
+		trivial-garbage-20200925-git.tgz:trivialgarbage \
+		trivial-gray-streams-20210124-git.tgz:trivialgraystreams \
+		trivial-utf-8-20200925-git.tgz:trivialutf8 \
+		trivial-with-current-source-form-20200427-git.tgz:trivialwithcurrentsourceform \
+		uax-15-20210124-git.tgz:uax15 \
+		usocket-0.8.3.tgz:usocket \
+		uuid-20200715-git.tgz:uuid \
+		yason-v0.7.8.tgz:yason \
+		zs3-1.3.3.tgz:zs3
+DIST_SUBDIR=	pgloader
 
-MAINTAINER=	ports@FreeBSD.org
-COMMENT=	Data loading tool for PostgreSQL,using the COPY command
+MAINTAINER=	freebsd-washroom@duhanic.com
+COMMENT=	Data loading and migration tool for PostgreSQL using the COPY command
 
 LICENSE=	PostgreSQL
 
-BROKEN=		fails to build
-
-BUILD_DEPENDS=	ccl:lang/ccl
+BUILD_DEPENDS=	sbcl:lang/sbcl
 LIB_DEPENDS=	libsqlite3.so:databases/sqlite3 \
 		libtdsodbc.so:databases/freetds
 
-CONFLICTS=	pgloader-2*
-
 USES=		gmake
-
+MY_QLB_VER=	version-2015-01-28
+MY_QL_VER=	version-2021-02-13
+MY_QL_SW=	build/quicklisp/dists/quicklisp/software
+MY_QL_LP=	build/quicklisp/local-projects
 USE_GITHUB=	yes
-GH_ACCOUNT=	dimitri
-GH_TUPLE=	amutu:quicklisp_offline:e9008cc:qlp/build/quicklisp
-
-PLIST_FILES=	bin/pgloader \
-		bin/pgloader3 \
-		man/man1/pgloader.1.gz
+GH_TUPLE=	dimitri:pgloader: \
+		quicklisp:quicklisp-bootstrap:${MY_QLB_VER}:qlb \
+		quicklisp:quicklisp-client:${MY_QL_VER}:ql \
+		qitab:qmynd:7e56daf7:qmynd/${MY_QL_LP}/qmynd \
+		dimitri:cl-ixf:ed26f87e:clixf/${MY_QL_LP}/cl-ixf \
+		dimitri:cl-db3:38e5ad35:cldb3/${MY_QL_LP}/cl-db3 \
+		AccelerationNet:cl-csv:68ecb5d8:clcsv/${MY_QL_LP}/cl-csv
 
-MAKE_ARGS=	CL=ccl
-MAKE_ENV=	ASDF_OUTPUT_TRANSLATIONS=/:
+MAKE_ARGS=	CL=sbcl
+MAKE_JOBS_UNSAFE=	yes
+PLIST_FILES=	bin/pgloader
 
-# stripping can break lisp binaries
+# don't strip away SBCL/CCL:
 STRIP=
 
-post-patch:
-	${LN} ${WRKSRC}/build/quicklisp/quicklisp.lisp ${WRKSRC}/build
+post-extract:
+	${RLN} ${WRKDIR}/quicklisp-bootstrap-${MY_QLB_VER}/quicklisp.lisp ${WRKSRC}/build
+	${RLN} ${WRKDIR}/quicklisp-client-${MY_QL_VER}/asdf.lisp ${WRKSRC}/build/quicklisp
+	${RLN} ${WRKDIR}/quicklisp-client-${MY_QL_VER}/setup.lisp ${WRKSRC}/build/quicklisp
+	${RLN} ${WRKDIR}/quicklisp-client-${MY_QL_VER}/quicklisp ${WRKSRC}/build/quicklisp
+	${MKDIR} ${WRKDIR}/quicklisp-client-${MY_QL_VER}/dists/quicklisp
+	${TOUCH} ${WRKDIR}/quicklisp-client-${MY_QL_VER}/dists/quicklisp/distinfo.txt
+	${TOUCH} ${WRKDIR}/quicklisp-client-${MY_QL_VER}/dists/quicklisp/releases.txt
+	${TOUCH} ${WRKDIR}/quicklisp-client-${MY_QL_VER}/dists/quicklisp/systems.txt
+	${MKDIR} ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/alexandria-20200925-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/anaphora-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/asdf-finalizers-20170403-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/asdf-system-connections-20170124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/babel-20200925-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/bordeaux-threads-v0.8.8 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/buildapp-1.5.6 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cffi_0.23.0 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/chipz-20190202-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/chunga-20200427-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-abnf-20200325-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-base64-20201016-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-containers-20200427-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-fad-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-interpol-20201220-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-log.1.0.1 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-markdown-20191227-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-mssql-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-mustache-20200325-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-ppcre-20190521-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-sqlite-20190813-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-unicode-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl-utilities-1.2.4 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cl+ssl-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/closer-mop-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/closure-common-20181018-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/command-line-arguments-20200325-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/cxml-20200610-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/drakma-v2.0.7 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/dynamic-classes-20130128-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/esrap-20201220-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/flexi-streams-20200925-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/garbage-pools-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/global-vars-20141106-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/ieee-floats-20170830-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/ironclad-v0.54 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/iterate-20200610-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/local-time-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/lparallel-20160825-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/md5-20180228-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/metabang-bind-20200218-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/metatilities-base-20191227-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/named-readtables-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/parse-number-v1.7 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/postmodern-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/puri-20201016-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/py-configparser-20170830-svn ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/quri-20201220-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/split-sequence-v2.0.0 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/trivial-backtrace-20200610-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/trivial-features-20200715-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/trivial-garbage-20200925-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/trivial-gray-streams-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/trivial-utf-8-20200925-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/trivial-with-current-source-form-20200427-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/uax-15-20210124-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/usocket-0.8.3 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/uuid-20200715-git ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/yason-v0.7.8 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/zs3-1.3.3 ${WRKSRC}/${MY_QL_SW}
+	${RLN} ${WRKDIR}/buildapp-1.5.6 ${WRKSRC}/${MY_QL_LP}
 
 do-install:
-	${INSTALL_PROGRAM} ${WRKSRC}/build/bin/pgloader ${STAGEDIR}${PREFIX}/bin/pgloader3
-	${INSTALL_SCRIPT} ${WRKSRC}/pgloader_wrapper.sh ${STAGEDIR}${PREFIX}/bin/pgloader
-	${INSTALL_MAN} ${WRKSRC}/pgloader.1 ${STAGEDIR}${MANPREFIX}/man/man1
+	${INSTALL_PROGRAM} ${WRKSRC}/build/bin/pgloader ${STAGEDIR}${PREFIX}/bin/pgloader
 
 .include <bsd.port.mk>
diff --git a/databases/pgloader3/distinfo b/databases/pgloader3/distinfo
index 0633adcfcc77..8de2074ffcf8 100644
--- a/databases/pgloader3/distinfo
+++ b/databases/pgloader3/distinfo
@@ -1,5 +1,135 @@
-TIMESTAMP = 1499825145
-SHA256 (dimitri-pgloader-v3.4.1_GH0.tar.gz) = 3ac4d03706057a35e1d4d0e63571b84be7d0d07ea09e015d90e242200488fe82
-SIZE (dimitri-pgloader-v3.4.1_GH0.tar.gz) = 4218005
-SHA256 (amutu-quicklisp_offline-e9008cc_GH0.tar.gz) = 2085b87b2c62b0eca85784995c86a66a0a202950c242e100273c9cea4cde0453
-SIZE (amutu-quicklisp_offline-e9008cc_GH0.tar.gz) = 4833120
+TIMESTAMP = 1613813074
+SHA256 (pgloader/alexandria-20200925-git.tgz) = d425c4106dbdf879d900d5979189c6df675323bd13cd0c0f80ea00a4ddb7fbb2
+SIZE (pgloader/alexandria-20200925-git.tgz) = 54730
+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-20201220-git.tgz) = 33cf9f99a3ee0716bc69cd29c035f5b1f2af8218924a9f36b6014594bc22117a
+SIZE (pgloader/esrap-20201220-git.tgz) = 69184
+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.2_GH0.tar.gz) = 33f87df9cb8f9a36f9836cd691ad6dfa72ae76200a12fe01ee89584f3b771ae7
+SIZE (pgloader/dimitri-pgloader-v3.6.2_GH0.tar.gz) = 3717111
+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
diff --git a/databases/pgloader3/files/patch-Makefile b/databases/pgloader3/files/patch-Makefile
index bca53923c3b3..f3578c196861 100644
--- a/databases/pgloader3/files/patch-Makefile
+++ b/databases/pgloader3/files/patch-Makefile
@@ -1,6 +1,6 @@
---- Makefile.orig	2017-07-06 14:53:29 UTC
+--- Makefile.orig	2020-03-22 21:26:18 UTC
 +++ Makefile
-@@ -84,7 +84,7 @@ $(QLDIR)/local-projects/cl-csv:
+@@ -86,7 +86,7 @@ $(QLDIR)/local-projects/cl-csv:
  
  $(QLDIR)/setup.lisp:
  	mkdir -p $(BUILDDIR)
@@ -9,30 +9,23 @@
  	$(CL) $(CL_OPTS) --load $(BUILDDIR)/quicklisp.lisp                        \
               --load src/getenv.lisp                                               \
               --eval '(quicklisp-quickstart:install :path "$(BUILDDIR)/quicklisp" :proxy (getenv "http_proxy"))' \
-@@ -97,7 +97,7 @@ clones: $(QLDIR)/local-projects/cl-ixf \
-         $(QLDIR)/local-projects/cl-csv \
-         $(QLDIR)/local-projects/qmynd ;
+@@ -126,7 +126,9 @@ $(BUILDAPP_CCL): $(QLDIR)/setup.lisp
  
--$(LIBS): $(QLDIR)/setup.lisp clones
-+$(LIBS): $(QLDIR)/setup.lisp
- 	$(CL) $(CL_OPTS) --load $(QLDIR)/setup.lisp                 \
-              --eval '(push "$(PWD)/" asdf:*central-registry*)'      \
-              --eval '(ql:quickload "pgloader")'                     \
-@@ -113,7 +113,7 @@ $(MANIFEST): $(LIBS)
- 
- manifest: $(MANIFEST) ;
- 
--$(BUILDAPP_CCL): $(QLDIR)/setup.lisp
-+$(BUILDAPP_CCL): $(QLDIR)/setup.lisp $(LIBS)
+ $(BUILDAPP_SBCL): $(QLDIR)/setup.lisp
  	mkdir -p $(BUILDDIR)/bin
- 	$(CL) $(CL_OPTS) --load $(QLDIR)/setup.lisp               \
+-	$(CL) $(CL_OPTS) --load $(QLDIR)/setup.lisp               \
++	cd $(BUILDDIR)/quicklisp/dists/quicklisp/software/buildapp-1.5.6/ && LISP=$(CL) gmake
++	mv $(BUILDDIR)/quicklisp/dists/quicklisp/software/buildapp-1.5.6/buildapp $(BUILDDIR)/bin/buildapp.sbcl
++#$(CL) $(CL_OPTS) --load $(QLDIR)/setup.lisp               \
               --eval '(ql:quickload "buildapp")'                   \
-@@ -176,7 +176,7 @@ $(BUNDLE): $(BUNDLEDIR)
+              --eval '(buildapp:build-buildapp "$@")'              \
+              --eval '(quit)'
+@@ -199,7 +201,7 @@ $(BUNDLE): $(BUNDLEDIR) $(BUNDLEDIR)/version.sexp
  	sed -e s/%VERSION%/$(VERSION)/ < bundle/Makefile > $(BUNDLEDIR)/Makefile
  	git archive --format=tar --prefix=pgloader-$(VERSION)/ master \
  	     | tar -C $(BUNDLEDIR)/local-projects/ -xf -
 -	make QLDIR=$(BUNDLEDIR) clones
-+	make QLDIR=$(BUNDLEDIR)
++#	make QLDIR=$(BUNDLEDIR) clones
  	tar -C build/bundle 		    \
              --exclude bin   		    \
              --exclude test/sqlite           \
diff --git a/databases/pgloader3/files/patch-pgloader__wrapper.sh b/databases/pgloader3/files/patch-pgloader__wrapper.sh
deleted file mode 100644
index 0f6137dd9c78..000000000000
--- a/databases/pgloader3/files/patch-pgloader__wrapper.sh
+++ /dev/null
@@ -1,11 +0,0 @@
---- pgloader_wrapper.sh.orig	2017-07-14 08:47:14 UTC
-+++ pgloader_wrapper.sh
-@@ -0,0 +1,8 @@
-+#!/bin/sh
-+
-+# There is a bug for current ccl on FreeBSD, which is  determine_executable_name
-+# doesn't do the job for FreeBSD. Now we use this script as a workaround. See:
-+# https://github.com/Clozure/ccl/issues/38
-+
-+BIN_DIR="$(cd $(/usr/bin/dirname $0);pwd)"
-+exec "${BIN_DIR}"/pgloader3 "${@}"
diff --git a/databases/pgloader3/pkg-descr b/databases/pgloader3/pkg-descr
index d9e93db9ed4e..9438138e4903 100644
--- a/databases/pgloader3/pkg-descr
+++ b/databases/pgloader3/pkg-descr
@@ -1,9 +1,11 @@
-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.
+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.
 
-WWW: http://pgloader.io
+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.
+
+WWW: https://pgloader.io