dimitri / pgloader

Migrate to PostgreSQL in a single command!
http://pgloader.io
Other
5.45k stars 548 forks source link

sqlite to postgresql (Windows + Docker) #1548

Open FeckNeck opened 11 months ago

FeckNeck commented 11 months ago

I'm attempting to migrate a simple sqlite db file to postgresql with the following command :

docker run --rm -it dimitri/pgloader:latest pgloader F:\pgloader-test\test.db postgresql://example:example@host.docker.internal/example

The command seems to work since I have no errors as you can see from the image: image I'm running postgresql throught Docker and here is my docker-compose.yml file :

# Use postgres/example user/password credentials
version: "3.1"

services:
  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_USER: example
      POSTGRES_PASSWORD: example
      POSTGRES_DB: example
    ports:
      - 5432:5432

I've tried adding --verbose, --debug, --type sqlite and sqlite:\F:\pgloader-test.db but it still doesn't work. I thought the problem might be with the .db file I'm trying to migrate. So, tried exporting from https://sqliteonline.com/ from the demo table's default config and it still doesn't work.
I can connect to my postgres example database and create tables.
I don't really understand where my error is coming from. Thanks in advance for your help

w0pr commented 11 months ago

I had the same problem and I rebuild from source with Clozure CL instead of SBCL and it worked... https://github.com/dimitri/pgloader/issues/1543