pgloader

pgloader copied to clipboard

Hi, I'm trying to migrate from MySQL (MariaDB) to PostgreSQL, using a context file. ```sh $ cat directory.ini [pgloader] MYSQL_DBPATH=mysql://[email protected]::3306/directory PG_DBPATH=postgresql://[email protected]/directory DB_NAME=directory $ cat mysql2pg.load LOAD DATABASE FROM {{ MYSQL_DBPATH...

frague59

pgloader MySQL to PostgreSQL Conversion Heap Issues

2

I am attempting to migrate from MySQL to PostgreSQL via pgloader. MySQL Version: 8.0.37 MySQL Community Server PostgreSQL Version: 15.12 pgloader Version: pgloader version "3.6.7~devel" compiled with SBCL 2.2.10-1.rhel9 Here...

zatowle

Urlencode connection string not working with &

2

In this commit https://github.com/dimitri/pgloader/commit/d1fce3728af99a60f40582b015e89a0f203d3961 You add support to allow urlencode some components of connection strings but it does not work if we try to url encode two components: into {{...

crazyhouse33

Hi, I try to load data of Metabase from MySQL to PostgreSQL using pgloader but always get the error message `The value NIL is not of type PGLOADER.CATALOG:COLUMN`. - pgloader...

teeravee

Hi, I need to change the default datetime cast rules. However simply copying them to `.load` fails with parsing error. My load ``` LOAD DATABASE FROM mysql://db:[email protected]:12826/db INTO postgresql://db:[email protected]:5433/db WITH...

FluffyDiscord