xTuple.com xTupleU Blog & News Customer Support

Error restore PostgreSQL databse on QNAP

Hi all,

for data security we want to have the xtuple-ERP running on a QNAP which now offers PostreSQL-Support (also, we bought quite a good QNAP-solution, should be several times faster...). The postgreSQL database which is automatically installed is version 9.3.4. We made a backup from our actual Microsoft Windows Server running PostgreSQL 9.3.11, we use the actual xtuple version 4.9.3. The restore of the dump on the same server runs without problems. Yet on the QNAP I receive the error message:

pg_restore: [archiver (db)] error returned by PQputCopyData: could not send data to server: Software caused connection abort (0x00002745/10053) and then the process is ended with Exitcode 1. 

The last line before was

pg_restore: processing data for table "public.gltrans" but that is not consistent, the "last line" is each time different, e.g. second attempt it stopped after pg_restore: processing data for table "public.report"

I connect via pgAdmin III Version 1.22.0

Any ideas how to fix that issue?

Thank you very much!

Regards

Arne