pgloader
pgloader copied to clipboard
dimitri
Migrate to PostgreSQL in a single command!
I built a discord bot and used EFCore for the data layer, so I could abstract the database provider. I use the Migrations to create the database schema, and initial...
# Postgres 18 UUID7 support Would it be possible to add **Postgres 18** `UUID7` support to [MS SQL rules](https://github.com/dimitri/pgloader/blob/master/src/sources/mssql/mssql-cast-rules.lisp), please?
from mysql to postgres > 2025-11-18T07:50:33.016000Z LOG pgloader version "3.6.10~devel" 2025-11-18T07:50:33.129001Z LOG Migrating from # 2025-11-18T07:50:33.129001Z LOG Migrating into # 2025-11-18T07:50:49.420139Z ERROR Database error 42601: syntax error at or near...
connexion Issue with PgLoader : ~$ pgloader --debug --verbose --dry-run ms.load pgloader version 3.6.3~devel compiled with SBCL 2.1.11.debian sb-impl::*default-external-format* :UTF-8 tmpdir: #P"/tmp/pgloader/" 2025-10-14T10:42:02.004001Z NOTICE Starting pgloader, log system is ready....
pgloader 3.6.7~devel skips [sqlite generated columns](https://sqlite.org/gencol.html) when importing to postgres. I'd expect this to translate to [postgres generated columns](https://www.postgresql.org/docs/current/ddl-generated-columns.html). ### Minimal repro Step 1: create a sqlite database with a...
I'm using pgloader v3.6.9 and I am unable to use exclude or include inside or outside the WITH statement in a .load file with or without regex. I've went around...
In Ubuntu 18.04.02 Desktop I'm trying to load a sqlite database into postgres-11: (base) marco@marco-U36SG:~/turnserver-4.5.0.8/examples/var/db$ pgloader --debug --verbose /home/marco/turnserver-4.5.0.8/examples/scripts/longtermsecuredb/turndb ./turndb postgresql:///new_pg_appdb sb-impl::*default-external-format* :UTF-8 tmpdir: #P"/tmp/pgloader/" KABOOM! FATAL error: :UTF-8 stream...
## Steps to reproduce Run the following command: ```bash $ pgloader "mysql://[email protected]/foo" "postgresql://[email protected]" ``` ## Expected result pgloader recognizes the second argument as a PostgreSQL database URI and proceeds. ##...
## Description I’m migrating data from an existing SQLite database into a PostgreSQL database using `pgloader`. My PostgreSQL target database already has some tables created by Alembic migrations (for example,...
