👋 I'm very excited about using supabase! I'm trying to migrate my db (sqlite3) to supabase using pgloader. I'm admittedly new to pgloader -- and I keep getting this error. I have no problems connecting directly using psql. Any tips or pointers? 🙏

docker exec -it loader pgloader dev.sqlite3 postgres://postgres:PASSWORD@db.xyz.supabase.co:5432/postgres

➡️ > 2022-06-05T13:12:56.037000Z LOG pgloader version "3.6.3~devel" > 2022-06-05T13:12:56.045000Z LOG Data errors in '/tmp/pgloader/' > KABOOM! > FATAL error: Failed to connect to pgsql at "db.xyz.supabase.co" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8). > An unhandled error condition has been signalled: > Failed to connect to pgsql at "db.xyz.supabase.co" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).

Hello @hirefrank! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

https://github.com/dimitri/pgloader/issues/1183 seems like same issue

hirefrank (2022-06-05)

yeah, ugh -- i just found that. i guess i'll convert to a local postgres db, then dump, then import.