error from command line invocation

[Brent-Wood]

I'm not sure this is a bug, but can't find any pgloader support forum apart from this.

• [ ] pgloader --version 3.4.1 on Mint Linux

• [ ] did you test a fresh compile from the source tree? standard install from deb package

• [ ] did you search for other similar issues? yes

• [ ] how can I reproduce the bug? I'm trying to ingest a csv (age_kah2001_t_catalog.csv) into an existing table (t_catalog) in the age schema in the fish2 database pgloader -vd --with "skip header = 1" --type csv postgresql:///fish2?age.t_catalog age_kah2001_t_catalog.csv

The error is: can't find the TRUENAME of wild pathname /home/woodb/pg_ingest/postgresql:/fish2?age.t_catalog(physicalized from postgresql:///fish2?age.t_catalog).

I have tried a variety of approaches to passing the target database/schema/table names via the command line & always get the same error.

Any advice appreciated.

[phoe]

Can you try with the most recent version, 3.6.2? Does the issue still persist there?

[solracsf]

I'm having the same error with 3.6.2, importing from live MySQL to live PostgreSQL:

pgloader mysql://db:[email protected]:3307/db postgresql://db:[email protected]/db?sslmode=require --no-ssl-cert-verification

KABOOM!

FATAL error: Can't find the TRUENAME of wild pathname /root/postgresql:/db:[email protected]/db?sslmode=require (physicalized from postgresql://db:[email protected]/db?sslmode=require).

An unhandled error condition has been signalled:

Can't find the TRUENAME of wild pathname /root/postgresql:/db:[email protected]/db?sslmode=require (physicalized from postgresql://db:[email protected]/db?sslmode=require).

2020-12-28T13:48:55.018000Z LOG pgloader version "3.6.2"

What I am doing here?

Can't find the TRUENAME of wild pathname /root/postgresql:/db:[email protected]/XzN1Lqz?sslmode=require (physicalized from postgresql://db:[email protected]/db?sslmode=require).

[classicPintus]

I'm having the same error with 3.6.2, importing from live MySQL to live PostgreSQL:

pgloader mysql://db:[email protected]:3307/db postgresql://db:[email protected]/db?sslmode=require --no-ssl-cert-verification

KABOOM!

FATAL error: Can't find the TRUENAME of wild pathname /root/postgresql:/db:[email protected]/db?sslmode=require (physicalized from postgresql://db:[email protected]/db?sslmode=require).

An unhandled error condition has been signalled:

Can't find the TRUENAME of wild pathname /root/postgresql:/db:[email protected]/db?sslmode=require (physicalized from postgresql://db:[email protected]/db?sslmode=require).

2020-12-28T13:48:55.018000Z LOG pgloader version "3.6.2"

What I am doing here?

Can't find the TRUENAME of wild pathname /root/postgresql:/db:[email protected]/XzN1Lqz?sslmode=require (physicalized from postgresql://db:[email protected]/db?sslmode=require).

I've exactly the same error. Please can we help us?

[mcg]

Getting this myself. Any resolution? #1428 also looks like the same thing.