pgloader
pgloader copied to clipboard
dimitri
Migrate to PostgreSQL in a single command!
pgloader version 3.6.7~devel compiled with SBCL 2.1.1.debian sb-impl::*default-external-format* :UTF-8 tmpdir: #P"/tmp/pgloader/" 2024-07-05T14:03:50.016001Z NOTICE Starting pgloader, log system is ready. 2024-07-05T14:03:50.052003Z INFO Starting monitor 2024-07-05T14:03:50.084005Z LOG pgloader version "3.6.7~devel" 2024-07-05T14:03:50.196011Z INFO...
- [x] pgloader --version ``` pgloader version "3.6.7~devel" compiled with SBCL 2.1.11.debian ``` - [x] did you test a fresh compile from the source tree? - [x] did you search...
- [x] pgloader --version ``` pgloader version "3.6.1" compiled with SBCL 1.4.0-1.el7 ``` - [x] did you test a fresh compile from the source tree? Yes - [x] did you...
This was never implemented for pgsqlpgsql migrations. Fixes: #1550
migrate.load file data: ``` LOAD DATABASE FROM mssql://user:[email protected]/Configuration INTO postgresql://user:[email protected]/Configuration?sslmode=require WITH include no drop, create tables, create indexes, reset sequences, data only SET work_mem to '16MB', maintenance_work_mem to '512 MB';...
When moving data MSSQL -> Postgres indexes with names containing a dash gave errors.
This PR is to update Dockerfile.ccl to prevent the encoding problem when migrating from MSSQL, same with what have already done in the normal Dockerfile with SBCL.
Sorry, the bug report below probably does not meet the minimal requirements. However, /usr/bin/pgloade is a binary and the error message even with debug just does not give me a...
Pgloader version: ``` pgloader version "3.6.7~devel" compiled with SBCL 2.2.9.debian ``` I'm trying to load an sqlite column with the sqlite jsonb type (https://sqlite.org/draft/jsonb.html) into a postgres column with the...
pgloader omits "DEFAULT NULL" clauses when (column-default column) is NIL. With this patch "DEFAULT NULL" clauses are also omitted when (column-default column) is :NULL.