• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Postgresql bulk import copy

#1 2012-03-20 10:32:22

MerlinDerKoenig
New member
Registered: 2008-01-24
Posts: 3

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

Offline

#2 2012-03-20 11:45:54

MerlinDerKoenig
New member
Registered: 2008-01-24
Posts: 3

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


Uploaded Images

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Postgresql bulk import copy

Board footer

Powered by FluxBB