pgloader
pgloader copied to clipboard
Migrate to PostgreSQL in a single command!
Hi, We are migrating MySQL DB to PostgreSQL DB (both are hosted on Azure). And we receive very strange error: ``` [root@vm-test home]# pgloader --debug commands.load pgloader version 3.6.1 compiled...
- [ ] pgloader --version ``` ``` - [ ] did you test a fresh compile from the source tree? - [ ] did you search for other similar issues?...
FDW (Foreign Data Wrapper) is a build-in solution for loading external files... Load and Transform, all by standard SQL language. Perhaps the PGLoader's premise can be reviewed, and a PGLoader's...
I am trying to run migration using pgloader latest docker image and during the migration it seems to crash on some fields. This does not happen on locally installed 3.6.2...
1. I believe I'm having the same issue as https://github.com/dimitri/pgloader/issues/1193 - intermittent "BUSY: database is locked" 2021-12-11T17:22:45.041000Z LOG pgloader version "3.6.2" 2021-12-11T17:22:45.171000Z LOG Migrating from # 2021-12-11T17:22:45.171000Z LOG Migrating into...
- [x] pgloader --version ``` pgloader version "3.6.2" compiled with SBCL 2.0.6.debian ``` - [ ] did you test a fresh compile from the source tree? I did not, tbh....
pgloader version: 3.6.3 I ran the command as: pgloader mysql://root:{password}%mysql_addr:port/tmpdata postgresql://pgname:pgpasswod@pg_addr:port/tmpdata It reports as FATAL error: Failed to connect pgsql at "x.x.x.x" (port: x) as user: 10 fell through ECASE...
Please provide the following information: - [ ] pgloader --version ``` ``` - [ ] did you test a fresh compile from the source tree? - I installed it just...
I load several file into pg database using pgloader. Some are successful imported, while one file failed. "Heap exhausted" error occurs. #962,#16,$487,#327 show some solution, and I tried --with "prefetch...
- [x] pgloader --version ``` 3.6.2 ``` - [x] did you search for other similar issues? - [x] how can I reproduce the bug? ``` LOAD ARCHIVE FROM https://timezonedb.com/files/timezonedb.csv.zip INTO...