[go: up one dir, main page]

Skip to content

Creating security label in Postgresql 9.5 returns provider not loaded error

Hi, I'm installing postgresql anonymizer in my 9.5 local cluster using the steps provided in:

While the installation process didn't returned no errors when I try to create a security label on skynet's role I get the following error:

postgres=# SECURITY LABEL FOR anon ON ROLE skynet IS 'MASKED';
ERROR:  security label provider "anon" is not loaded

Recreating the pg_config table also didn't solve the problem;

postgres=# create extension anon;
ERROR:  extension "anon" already exists
postgres=# CREATE TEMPORARY TABLE pg_config AS SELECT 'SHAREDIR'::TEXT AS name, '/usr/share/postgresql/9.5'::TEXT AS setting;
SELECT 1
postgres=# select anon.load();
WARNING:  The path '/usr/share/postgresql/9.5/extension/anon/' does not exist. Data is not loaded.
 load 
------
 t
(1 row)

postgres=# SECURITY LABEL FOR anon ON ROLE skynet IS 'MASKED';
ERROR:  security label provider "anon" is not loaded

Am I missing a important step or something like it? Thanks.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information