PG_Restore getting "SSL connection has been closed unexpectedly"

1

I am trying to migrate over a postgres DB from a Heroku instance.

The restore works up until it gets stuck on a large-ish table and then I get: PQputCopyData: SSL connection has been closed unexpectedly

I am on the standard postgres plan. I have tried SSH’ing into the web app and doing the pg_restore locally but got a similarr error. I also tried the various suggested methods here for similar data loading issues and still get the same error message.

2

Hi there,

If you are exporting your data from Heroku using pg_dump can you try exporting your larger tables into a single dump file? The -t <table-name> option allows you to do this. Then import them into Render one table at a time.

Regards,

Keith
Render Support, UTC+10 :australia:

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.