Currently, we are having EB version 11 on the production environment and we need to bulk many data, from what I've heard we can use some tools called edbldr, but it came with great prospects for us, except you need to invoke it using superuser role, which in our environment it can't be done. We have been stuck in this case for days now. Can you help us to know if there is other tools that can do the same thing or why should edbldr use the superuser role?
Thank you and regards
Below links may help for your requirements :
EDB LOADER : (Must requires superuser privileges)
Could you please try with this approach and let us know in case of any concerns/issues.
Regarding your options we have an issue about copy, can we know-how many data we process and how many data being rejected by the system? And about the edbldr can we have some default profile (but not superuser) to run it?
Regarding copy statement,
Copy statement can work only if data is valid in the file. No record will be inserted if any record is invalid in the source file.
Regarding edbldr, you can get .bad file for rejected data and the rest of the records get loaded.
edbldr must run with superuser or superuser privileged user.
Ex: you can grant superuser privilege to normal user and run edbldr, you can revoke superuser privilege back. Ex: Below
edb=# alter user normal_user superuser;
[enterprisedb@localhost:~]$/usr/edb/as11/bin/edbldr userid=normal_user/Edbldr control=/home/enterprisedb/control.ctl -d edb -p 5444
edb=# alter user normal_user nosuperuser;
Please let us know if you have any concerns.
You can use those tools with the EDB postgres as well, however, the functionality of those tools is similar to EDB Loader. We recommend to use the EDB Loader with EDB postgres and also if you want to test other tools, please do that first in the test environment.