corpus.blog
56,966 blogs · 4,417,066 posts Claim your blog
Record · corpus.blog/posts/01a087db-0b6d-727d-b3d8-92dc74fbfc5c

How to migrate Magnetico SQLite database dump to PostgreSQL

samuel.forestier.app · published 3 January 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at samuel.forestier.app Wayback capture
0blogs citing
First cited
—
Most recent
—
Rank this month
not ranked
Links from this post
26
Words captured
2,416

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://tgragnato.it/magnetico/
tgragnato.it
https://en.wikipedia.org/wiki/Mainline_DHT
en.wikipedia.org
https://en.wikipedia.org/wiki/From_Zero
en.wikipedia.org
https://tnt.maiti.info/dhtd/
tnt.maiti.info
https://github.com/boramalper/magnetico/issues/218
github.com
https://github.com/boramalper/magnetico/issues/280
github.com
https://pkg.go.dev/gitlab.com/skobkin/magnetico-go-migrator
pkg.go.dev
https://framagit.org/Glandos/magnetico_merge
framagit.org
https://pgloader.io/
pgloader.io
https://stackoverflow.com/questions/4581727/how-to-convert-sqlite-sql-dump-file-to-postgresql
stackoverflow.com
https://github.com/dimitri/pgloader/issues?q=sort%3Aupdated-desc+is%3Aissue+is%3Aopen
github.com
https://github.com/dimitri/pgloader/issues/1256
github.com
https://pgloader.readthedocs.io/en/stable/ref/sqlite.html
pgloader.readthedocs.io
https://pgloader.readthedocs.io/en/latest/command.html?highlight=prefetch%20rows
pgloader.readthedocs.io
https://github.com/dimitri/pgloader/issues/1547
github.com
https://www.depesz.com/2010/03/07/error-invalid-byte-sequence-for-encoding/
depesz.com
https://github.com/jackc/pgx/discussions/1554
github.com
https://github.com/dimitri/pgloader/issues/1250
github.com
https://m.ichael.dk/post/converting-sqlite3-to-postgres/
m.ichael.dk
https://www.postgresql.org/docs/current/datatype-binary.html
postgresql.org
https://fle.github.io/temporarily-disable-all-indexes-of-a-postgresql-table.html
fle.github.io
https://www.postgresql.org/docs/current/sql-reindex.html
postgresql.org
https://www.hendrik-erz.de/post/why-you-shouldnt-use-sqlite
hendrik-erz.de
https://www.postgresql.org/docs/current/app-pgdump.html
postgresql.org
https://github.com/tgragnato/magnetico/pull/607
github.com
https://github.com/tgragnato/magnetico/issues/651
github.com