Thanks @bryan I just made an attempt to
Thanks @bryan I just made an attempt to do the migration anyways to see if it would complete. Ended up with:
pg_restore: error: error returned by PQputCopyData: SSL connection has been closed unexpectedly
Is this related to incompatibilities? or is it a connection issue? I got my tables created - but no data. And should I be using a pooling connection?
3 Replies
flat-fuchsia•10mo ago
oh that's likely due to the pooling URL if you're using that
use the direct connection for this, the connection pooler will timeout and give errors.
We are trying to detect this in the migration assistant but it seems you can only know you're using a pooler via the URL
distinguished-blush•10mo ago
thanks @bryan I got this working 🙂
one off-topic question... in terms of schema diff. does that only work when i add a new schema via the sql editor? lets say I create a new table or field via my CMS. does schema diff pick this up? or is there a way to pick up that change?
thus far - when i create a new table via my CMS or add a new column - these don't get picked up.
the goal is to build branches - but use the CMS to create fields, etc.
flat-fuchsia•10mo ago
great to hear!
schema diff generally works between two branches. most often people create a new branch to test it out before they merge that change into main. you can always create a branch after the fact if you changed schema on the main branch. branches can be created from previous versions of a branch.