topic Re: [resolved] postgresql bulk loading is erroring out if the DB is on remote server. in Talend Studio

[resolved] postgresql bulk loading is erroring out if the DB is on remote server.

Anonymous — Sat, 16 Nov 2024 13:40:12 GMT

I am trying to load a txt file on my Desktop into a remote DB server. It is erroring out with following messege.
"org.postgresql.util.PSQLException: ERROR: could not open file "E:/projects/Talend/clients.txt" for reading: No such file or directory".
It works if i copy the file manually to the remote server and provide the path it works.
Can postgres bulkload operations work with file located on the Client machine (Where Talend is installed) & the DB is on a different server?
Thanks
Srinivas

Re: [resolved] postgresql bulk loading is erroring out if the DB is on remote server.

Anonymous — Tue, 24 Nov 2009 06:07:14 GMT

Hello

Can postgres bulkload operations work with file located on the Client machine (Where Talend is installed) & the DB is on a different server?

The file must exist on the server, so now you can use a ftp componnet to put the file to server first. eg:
tFileInputDelimited--->tPostgresOutputBulk
|
onsubjobok
|
tFtpPut
|
onSubjobok
|
tPostgreOutputBulkExec
Best regards
shong

Re: [resolved] postgresql bulk loading is erroring out if the DB is on remote server.

Anonymous — Tue, 24 Nov 2009 17:19:40 GMT

I tried the above solution earlier & it worked for me. Looks like there is no bulk load component to load the file from client directly.
Srinivas

Re: [resolved] postgresql bulk loading is erroring out if the DB is on remote server.

Anonymous — Wed, 25 Nov 2009 04:48:22 GMT

Hi sbethi, you are correct ... bulkloading is available only when the bulkload file resides on the same server as the db.

Re: [resolved] postgresql bulk loading is erroring out if the DB is on remote server.

Anonymous — Thu, 23 Oct 2014 14:50:15 GMT

Thank you.