https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutputBulkExec-temp-file-on-wrong-server/m-p/2373274#M136017 I have talend and the Postgresql database running on separate servers.&nbsp; <BR />The&nbsp;tPostgresqlOutputBulkExec&nbsp;component of my job is failing with a "file not found" error... <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Exception in component tPostgresqlOutputBulkExec_2_tPBE<BR />org.postgresql.util.PSQLException: ERROR: could not open file "/tmp/XXXX_YYYY.tmp" for reading: No such file or directory<BR /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)<BR /></TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />From looking at the help and web, I understand that the filename option of the tPostgresqlOutputBulkExec is a temporary file on the database host server, but I am seeing this file on the talend server. I have the host field set to the database servers FQDN ( dbserver.example.com ) . <BR />Why is tPostgresqlOutputBulkExec creating the file on the talend server? &nbsp;Is this a bug? <BR />Thanks <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAwl.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132558i5C0FC3A96E84C5A8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAwl.png" alt="0683p000009MAwl.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAwq.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138950i849DA6D312D4A2D8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAwq.png" alt="0683p000009MAwq.png" /></span> Mon, 04 Jul 2016 10:23:11 GMT Anonymous 2016-07-04T10:23:11Z https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutputBulkExec-temp-file-on-wrong-server/m-p/2373274#M136017 I have talend and the Postgresql database running on separate servers.&nbsp; <BR />The&nbsp;tPostgresqlOutputBulkExec&nbsp;component of my job is failing with a "file not found" error... <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>Exception in component tPostgresqlOutputBulkExec_2_tPBE<BR />org.postgresql.util.PSQLException: ERROR: could not open file "/tmp/XXXX_YYYY.tmp" for reading: No such file or directory<BR /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)<BR /></TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />From looking at the help and web, I understand that the filename option of the tPostgresqlOutputBulkExec is a temporary file on the database host server, but I am seeing this file on the talend server. I have the host field set to the database servers FQDN ( dbserver.example.com ) . <BR />Why is tPostgresqlOutputBulkExec creating the file on the talend server? &nbsp;Is this a bug? <BR />Thanks <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAwl.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132558i5C0FC3A96E84C5A8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAwl.png" alt="0683p000009MAwl.png" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAwq.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138950i849DA6D312D4A2D8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAwq.png" alt="0683p000009MAwq.png" /></span> Mon, 04 Jul 2016 10:23:11 GMT https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutputBulkExec-temp-file-on-wrong-server/m-p/2373274#M136017 Anonymous 2016-07-04T10:23:11Z https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutputBulkExec-temp-file-on-wrong-server/m-p/2373275#M136018 No this is not a bug, it is perhaps a missing information in the documentation. This component runs the bulk loader from the postgresql installation and this program expect a file on the postgresql server. A solution to solve this could be a NFS share mounted on the same mount point on your talend server and the postgresql server. Save your file in this NFS file system and it will work. Mon, 04 Jul 2016 22:20:14 GMT https://community.qlik.com/t5/Talend-Studio/tPostgresqlOutputBulkExec-temp-file-on-wrong-server/m-p/2373275#M136018 Anonymous 2016-07-04T22:20:14Z