pg_bulkload icon indicating copy to clipboard operation
pg_bulkload copied to clipboard

must use superuser??

Open darrkz opened this issue 6 years ago • 1 comments

I recently use pg_bulkload to load data to pg, then I found that the tool told me "must be superuser to use pg_bulkload"

I think this is not safe, is there a way to change this?

darrkz avatar Sep 05 '19 07:09 darrkz

pg_bulkload can only be used by superuser, Because pg_bulkload modifies files(table,index) directly for fast loading.

We will also add these restrictions(only allowed to superuser) to the manual.

kiskk avatar Aug 03 '20 07:08 kiskk