Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:troubleshooting-guide:postgresql:import:psql_unknown_error [July 17, 2020, 01:30:11 PM] (current)
alexandr.kirpichny created
Line 1: Line 1:
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/postgresql-migration|Ispirer SQLWays Product Page - Migration to PostgreSQL]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
  
 +====== psql:error: could not stat file "D:/xxx.txt": Unknown error ======
 +
 +**Symptoms**
 +
 +During the import into the PostgreSQL database when loading data into a table the following message arises: "psql:error: could not stat file "D:/xxx.txt": Unknown error".
 +
 +**Causes**
 +
 +  * PostgreSQL utility (psql.exe) of 11 version is not able to read the file with the data that is greater than 1GB (is a bug).
 +
 +**Solutions**
 +
 +  * Install previous version of psql and PgAdmin, for example 10 version.
 +
 +
 +  * Another workaround is to use "Divide Data File Into Parts" option in the SQLWays Wizard tool. In this option you can specify the size of the data files that will be generated during the conversion.
 +
 +{{:sqlways:troubleshooting-guide:postgresql:import:div_data_file.png|}}
 +
 +
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products/postgresql-migration|Ispirer SQLWays Product Page - Migration to PostgreSQL]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
sqlways/troubleshooting-guide/postgresql/import/psql_unknown_error.txt · Last modified: July 17, 2020, 01:30:11 PM by alexandr.kirpichny
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement