From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

Postgresql bulk import copy

Highlighted

Postgresql bulk import copy

Hi !
We are trying to import data from a file with the postgresql bulk component.
It fails because the copy command need superuser privilege (on postgresql). Does someone know how this command has been implemented ? There is indeed the copy command as OS command and the copy statement as psql statement. I think that the plugin uses the OS one and if it is so does anybody know why ?
From postgresql side :
psql
#\copy ...........
does not require superuser privilege but only GRANT INSERT on the table to wirte in.
Is there another way to bulk import respecting basic security policies ?
Thanks for you help
Regard
Highlighted

Re: Postgresql bulk import copy

You can find following screenshots :
? job Talend using bulk component :
o tpostgresqlOuputBulk : generate file
o tpostgresqlOuputBulkExec : integrate file
? properties of the component
Regards

2019 GARTNER 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

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