Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

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.



If you will face with some difficulties or will have any additional questions, please feel free to mail us: support@ispirer.com


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.