I’m moving from Heroku to Render, and I’d like to bring my data with me
I’ve tried psql with an sql export, and pg_restore with an sql/tar dump. Both start, continue for a bit, and then times out when a table with ~300.000 records is being restored. When using pg_restore I get this error:
error: error returned by PQputCopyData: SSL SYSCALL error: Operation timed out
I’m also experiencing this issue, and tried the proposed solution but ran into some issues. What’s causing this problem? Is there anything that can be done on render’s side in order to make this process easier? 300k+ records import on an app seems like it would be a common task.
I have created a separate post as this one has been solved here…