ifharry

1. Install https://pgloader.readthedocs.io/en/latest/install.html
2. Dump your D1 Database, npx wrangler d1 export <database_name> --remote --output=./d1_dump.sql
3. Import into your_database.db, sqlite3 your_database.db < d1_dump.sql
4. Load into PG, pgloader sqlite:///path/to/file.db pgsql://pguser@pghost/dbname

References

• https://developers.cloudflare.com/d1/best-practices/import-export-data/
  • https://developers.cloudflare.com/d1/best-practices/import-export-data/#known-limitations
  • https://developers.cloudflare.com/d1/best-practices/import-export-data/#export-an-existing-d1-database
• https://pgloader.readthedocs.io/en/latest/ref/sqlite.html