Stack Overflow
Stack Overflow

Questions tagged [pgloader]

75 questions
14
votes
2 answers

Build or Install pg_loader on Windows

I am running PostgreSQL 9.6 on a Windows 7 laptop that is tightly managed by corporate IT. I do not have admin privileges on this laptop, but can do "many" things, including software installation, through elevated rights granted through…
Michael Sheaver
  • 2,059
  • 5
  • 25
  • 38
12
votes
1 answer

pgloader - Failed to connect to mysql at "localhost" (port 3306) as user "root": Condition QMYND:MYSQL-UNSUPPORTED-AUTHENTICATION was signalled

I am trying to migrate my rails application from mysql to postgres. Since we have already running application so I am moving mysql data to postgres database using pgloader. But when I do pgloader mysql://root:root_password@127.0.0.1/mysql_database…
Harshwardhan Rathore
  • 249
  • 2
  • 12
7
votes
1 answer

Failed to migrate from Mysql 8 to postgres using pgloader

I'm trying to migrate from MySQL to PostgreSQL database. Is there any way to migrate from MySQL to PostgreSQL without modifying the my.cnf file? pgloader mysql://root:root_password@127.0.0.1/mysql_database…
aymen0406
  • 127
  • 10
4
votes
1 answer

PGLOADER no data imported - no errors (mysql to postgres migration)

I am using pgloader to migrate DB data from MySQL to Postgres and I set up everything as per their documentation but still no data imported. ubuntu@ip-123-31-13-119:/applications$ pgloader pgload.load pgloader Response: 2020-02-22T06:28:27.676000Z…
Ravindra Yadav
  • 619
  • 2
  • 6
  • 15
4
votes
2 answers

How to build pgloader on Windows (or CentOS7)?

I need to convert some MySQL databases to Postgresql. I came across the pgloader script, which promises to be the best solution, but coming from a Windows environment I have no idea how to build it. My server has CentOS7, but I have never compiled…
Dylan
  • 9,129
  • 20
  • 96
  • 153
3
votes
1 answer

Postgres doesn't respect Django's "on_delete = models.CASCADE" in models.py. Why?

I just migrated from SQLite3 to Postgres 12 (using pgloader). I can't delete certain model objects, because there are other model objects referencing to it. However, I'm very sure my model object has "on_delete = models.CASCADE" set in the…
Hmong Bong
  • 33
  • 6
3
votes
3 answers

pgloader: Heap exhausted, game over. problem

After writing the code, When I run my pgloader script, it fails this way: load database from mysql://xxx:yyy127.0.0.1/zzz into pgsql://xxx:yyy@localhost/zzz including only table names matching 'TABLE' with data only, create no tables,…
Felipe Valdes
  • 1,998
  • 15
  • 26
3
votes
1 answer

Migrate mysql to postgres using pgloader

I'm trying to migrate mysql to postgres using pgloader, since I'm using window so, I installed pgloader in windows linux subsystem, and I have used following command to migrate the DB pgloader mysql://root@localhost/f1db…
Saranraj K
  • 412
  • 1
  • 7
  • 19
3
votes
1 answer

How to insert NULL values into a PostgreSQL table

I have data in CSV file I am trying to insert into a postgresSQL table using pgloader. The input file is from MS SQL server export, and NULL values are already explicitly cast as NULL. My pgloader scripts seems to fail for the keywords NULL,…
Grooth
  • 65
  • 1
  • 6
3
votes
0 answers

migrating sqlite database to postgresql with pgloader

I am trying to migrate a database from sqlite to postgresql using pgloader. my sqlite database is called app.db. So run the following commands createdb new_pg_appdb pgloader ./app.db postgresql:///new_pg_appdb the pgloader command seems to import…
carl
  • 4,216
  • 9
  • 55
  • 103
2
votes
2 answers

How can I call a LISP function with &optional arg and colon like `(formato '((:year 0 4) (:month 4 6) (:day 6 8)))`

I am trying to perform a DB migration with pgloader and I would like to define a custom lisp transformation file for a datetime, but I don't know LISP (!) So I have cut&paste one of the pgloader transform functions and I tried to invoke it with no…
fero
  • 498
  • 4
  • 11
2
votes
1 answer

Pgloader change datetime from mysql to postgres

I tried to migrate mysql data to postgres. All works fine but when I see the datetime fields in postgres are 5 hours behind mysql. How can I do to disable whatever pgloader is doing? Thanks I'm using this command pgloader…
Javier Esquivel
  • 51
  • 3
2
votes
0 answers

How can I import specific table from MySQL to PostgreSQL with pgloader?

I have MySQL and PostgreSQL databases. And I want to migrate only one of 10 tables from MySQL to PostgreSQL with pgloader. Whole Database migrates with no problem.
Medevin
  • 405
  • 1
  • 5
  • 9
2
votes
1 answer

How to fix "the octet sequence #(130) cannot be decoded." in pgloader

I'm trying to migrate a database from sqlite to postgresql using pgloader. My sqlite db is data.db, so i try this pgloader ./var/data.db postgres://***@ec2-54-83-50-174.compute-1.amazonaws.com:5432/mydb?sslmode=require Output: pgloader version…
bechir
  • 334
  • 6
  • 13
2
votes
0 answers

How to run pgloader by skipping indexes?

Is it possible to run pgloader so that it excludes indexes? I can always create the indexes at the end when the entire process finishes. My database is like 10GB and I am getting a heap exhausted error: Heap exhausted during garbage collection: 576…
Blankman
  • 259,732
  • 324
  • 769
  • 1,199
1
2 3 4 5