pgloader
pgloader copied to clipboard
dimitri
Migrate to PostgreSQL in a single command!
- [ ] pgloader --version ``` pgloader version "3.6.2" compiled with SBCL 2.0.6.debian ``` pgloader.load: ``` LOAD DATABASE FROM mysql://pgloader_my:PASSWORD@IP_ADDRESS/DB_NAME INTO postgresql://DB_NAME:PASSWORD@localhost/DB_NAME WITH include drop, create tables INCLUDING ONLY TABLE...
`QMYND:MYSQL-UNSUPPORTED-AUTHENTICATION` attempting to load data from mysql 8.0.4-rc. I found that mysql's `default_authentication_plugin` changed in this version: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin That looked promising, but I got the same error after setting it...
- [x] pgloader --version ``` 3.6.2 ``` - [ ] did you test a fresh compile from the source tree? - [x] did you search for other similar issues? -...
I was trying to migrate database using command: ``` ./build/bin/pgloader --debug pgsql://user:[email protected]:1921/mydb pgsql://user:[email protected]:1922/dbtest ``` but the process stopped with error: ``` ... 2020-08-07T14:03:25.586000+08:00 DEBUG SET client_encoding TO 'utf8' 2020-08-07T14:03:26.068000+08:00 DEBUG...
Seems like a potential fix might be updating the freetds.conf but im not sure how to go about doing that for the docker image
pgloader fails with a fatel error when trying `pgloader `. - [x] pgloader --version ``` pgloader version "3.6.3~devel" compiled with SBCL 2.2.4 ``` - [x] did you test a fresh...
Thanks for contributing to [pgloader](https://pgloader.io) by reporting an issue! Reporting an issue is the only way we can solve problems, fix bugs, and improve both the software and its user...
It seems, that the `--no-ssl-cert-verification` option is ignored in newer versions of pgloader: ``` pgloader version 3.6.0925960 compiled with SBCL 2.0.1.debian sb-impl::*default-external-format* :UTF-8 tmpdir: #P"/tmp/pgloader/" 2022-02-09T01:12:28.008000+01:00 NOTICE Starting pgloader, log...
Ubuntu 20.04 pgloader --version pgloader version "3.6.3~devel" Is it possible to add a custom value to the one find in a column of a CSV files? Something like this: `HAVING...
- [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? - [x] did you...
