Out of Memory while Reading Tuples

Symptoms

During the export of big tables from PostgreSQL database through the ODBC connection the following message appears: “Out of memory while reading tuples.; memory allocation error”.

Cause

PostgreSQL ODBC DSN is not properly tuned on your PC.

Solution

Please, in the ODBC Administrator open the ODBC DSN that you use to connect to the PostgreSQL database, click the “Datasource” button and on “Advanced Options” page check the option “Use Declare/Fetch” in your PostgreSQL driver, like it is specified in the picture below:

If you have any other questions regarding the usage of our tool, please, contact our support team: support@ispirer.com