pgloader

pgloader copied to clipboard

FATEL error on "SET SQL_MODE = "NO_AUTO_"

1

Hello, I did a mysql dump normal way and try to convert it. But I get this error: ``` 2022-06-15T17:54:01.054000Z LOG pgloader version "3.6.1" KABOOM! FATAL error: At SET SQL_MODE...

poudenes

Issue loading IXF file in target table with fileds default

3

HI, I'm loading ixf file by pgloader from ixf file but pgloader throws this exception . I try to drop the default value from the fields but the issue is...

grosa69

FATAL non whitespace after quoted data

2

Hi. Yes, I know about this one [765](https://github.com/dimitri/pgloader/issues/765) but there is a new case which causes this error. I have csv file and one of the columns contains such string:...

id-gena

PGloader - How to pass connection string in pgloader as environment variables

3

LOAD CSV FROM '/dbf/appworx/pgscript/temp_table_data.csv' (INV_ID) INTO postgresql://username:password@hostname:portname/dbname TARGET TABLE temp_inv_table Running through shells script - #!/bin/ksh echo "Start" #enviroment variable . /xzy/DBset echo "Fetching password value" pgloader temp_table_load2.load How do...

SamirMjs

We have issue while setting default value. Right now we are doing at Table level. Let me know how do set "Current_date", Nextval to default coumns

SamirMjs

- [x] pgloader --version ```console pgloader version "3.6.2" compiled with SBCL 2.0.11 ``` - [ ] did you test a fresh compile from the source tree? No. - [x] did...

ejstembler

Hi, I am trying to load a CSV into a Google Cloud SQL for PostgreSQL database?. I have verified that the connection from the source to the destination is correct:...

jacra3099

"with encoding option" getting runtime error with SBCL "is not of type HASH-TABLE"

4

- [ ] pgloader --version ``` SBCL 2.1.2 ``` - [ Yes] did you test a fresh compile from the source tree? - [ Yes] did you search for other...

suranjan

Heap exhausted during garbage collection

52

While trying to run a full new import using fresh pgloader container, I stumbled upon ``` 2019-05-07T11:56:36.063000Z DATA < #(" 0" "1e73536d-364a-4ac5-9556-26080ae675be" "a2159ea6-dcd4-4bfb-a659-8a30d17471a3" " 7" "000" "0" " 0" "008"...

AnrDaemon

syntax error at or near "unsigned" (checked previously closed issues)

6

Tried running the basic command from mysql to postgresql ```docker run --rm --name pgloader dimitri/pgloader:latest pgloader "mysql://remote.database1.com" "postgresql://remote.database2.com"``` Versions: - Mac OS 3.6.2, compiled with SBCL 2.0.11 (Homebrew) - Where...

mdhornet90