topic how to resolve tgreenplumbulkexec component error-must be superuser to copy in Talend Studio

how to resolve tgreenplumbulkexec component error-must be superuser to copy

sunny3 — Fri, 15 Nov 2024 23:09:49 GMT

hi,, i am getting below ierror in talend after using the tgreenplumexec componet.. how to resolve this error.

Re: how to resolve tgreenplumbulkexec component error-must be superuser to copy

gjeremy1617088143 — Thu, 03 Mar 2022 10:31:16 GMT

Hi, it seem in this post there is a similar issue and possible workaround :

https://community.talend.com/s/article/Insufficient-Privilege-must-be-superuser-to-COPY-to-or-from-a-file-error-when-importing-a-file-into-PostgreSQL-DB-YlB0p?language=en_US

Send me love and kudos

Re: how to resolve tgreenplumbulkexec component error-must be superuser to copy

Anonymous — Fri, 04 Mar 2022 02:48:08 GMT

Hello,

Are you getting this issue in V 7.3.1? The article "Insufficient Privilege must be superuser to COPY to or from a file' error when importing a file into PostgreSQL DB" maybe not a solution If you want to import the data automatically into a database with Talend and not with a command line console. Did you use any tGreeplumGPLoad component in your work flow?

Best regards

Sabrina

Re: how to resolve tgreenplumbulkexec component error-must be superuser to copy

sunny3 — Fri, 04 Mar 2022 08:58:29 GMT

I could not configure it.. requirement is :i have input file in a server .i need to load the data to a greenplum table. so can i use greenplum gpload for it?

Re: how to resolve tgreenplumbulkexec component error-must be superuser to copy

Anonymous — Mon, 07 Mar 2022 08:04:52 GMT

Hello,

Firstly, please make sure you are able to execute the gpload.py command from the Windows command Line.

Here is online component reference about: tgreenplumgpload

https://help.talend.com/r/en-US/8.0/greenplum/tgreenplumgpload

Best regards

Sabrina