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

One Star

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

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

Accepted Solutions
Employee

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

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

View solution in original post


All Replies
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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
Employee

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

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

View solution in original post

One Star

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

Thank you.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog