Export and import fails with ERROR: temporary file size exceeds temp_file_limit

[Jarmo Isotalo]

Hi All,

We were just trying to use the export to bucket and import from bucket features to migrate data from an PostgreSQL 9.4 instance to a fresh PostgreSQL 11 instance.

However, after importing for about 10 minutes the import failed with  

ERROR: temporary file size exceeds temp_file_limit (1541626kB) CONTEXT: parallel worker Import error: exit status 3

The source dataset is fairly small at 17G reported by the storage usage.

ps. Is there a better place to report issues like this; we are still waiting for the activation of our paid role-based support...

[Jarmo Isotalo]

I realized we can tweak that setting under the database flags

[Amit Sinha]

Hello Jarmo, as you already figure out the flag, I am sharing the document related to this which might be helpful for the details [1]

[1] https://cloud.google.com/sql/docs/postgres/flags#list-flags-postgres

[Jarmo Isotalo]

Thanks! We were just confused about how creating and trying to restore an instance with the default settings failes. 

Cheers,

Jarmo

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4add93e8-1ce8-4a77-9419-3f1e6e3838a9%40googlegroups.com.