Re: No enough privileges for autovacuum worker

2021-03-25 Thread Adrian Klaver
On 3/25/21 1:25 AM, Андрей Сычёв wrote: Because in trigger where table fpbackup.fp_vpn_data_2021w12 has been created there are several DDL commands: EXECUTE 'CREATE TABLE "' || fp_schema_name || '"."' || fp_table_name || '" (LIKE '|| fp_parent_table_name || ' INCLUDING DEFAULTS INCLUDING

Re: No enough privileges for autovacuum worker

2021-03-25 Thread Андрей Сычёв
Because in trigger where table fpbackup.fp_vpn_data_2021w12 has been created there are several DDL commands: EXECUTE 'CREATE TABLE "' || fp_schema_name || '"."' || fp_table_name || '" (LIKE '|| fp_parent_table_name || ' INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES) WITHOUT O

Re: No enough privileges for autovacuum worker

2021-03-24 Thread Adrian Klaver
On 3/24/21 1:16 AM, Андрей Сычёв wrote: I finally figured out how to tackle the problem: 1. When I manually execute ANALYZE on the table the error remains: [34938]-[192.168.67.81]-[DBeaver 7.3.2 - SQLEditor ]-[client backend]-[42501]-[postgres@fpdb] CONTEXT: SQL function "trigrams_vector" dur

Re: No enough privileges for autovacuum worker

2021-03-24 Thread Андрей Сычёв
I finally figured out how to tackle the problem: 1. When I manually execute ANALYZE on the table the error remains: [34938]-[192.168.67.81]-[DBeaver 7.3.2 - SQLEditor ]-[client backend]-[42501]-[postgres@fpdb] CONTEXT: SQL function "trigrams_vector" during inlining [34938]-[192.168.67.81]-[DBe

Re: No enough privileges for autovacuum worker

2021-03-23 Thread Adrian Klaver
On 3/23/21 9:45 AM, Андрей Сычёв wrote: I do not know who is running dict.trigrams_vector. There is no explicit call for this function. It is used implicitly in the index definition for the table fpbackup.fp_vpn_data_2021w12: CREATE INDEX fp_vpn_data_2021w12_trigrams_vector_idx ON fpbackup.f

Re: No enough privileges for autovacuum worker

2021-03-23 Thread Андрей Сычёв
I do not know who is running dict.trigrams_vector. There is no explicit call for this function. It is used implicitly in the index definition for the table fpbackup.fp_vpn_data_2021w12: CREATE INDEX fp_vpn_data_2021w12_trigrams_vector_idx ON fpbackup.fp_vpn_data_2021w12 USING gin (dict.trigram

Re: No enough privileges for autovacuum worker

2021-03-23 Thread Андрей Сычёв
Sorry, my mistake, but actually trigrams_array is called by trigrams_vector Definition for the function dict.trigrams_vector: CREATE OR REPLACE FUNCTION dict.trigrams_vector(word text) RETURNS tsvector LANGUAGE sql IMMUTABLE STRICT AS $function$ SELECT array_to_string(dict.trigrams_ar

Re: No enough privileges for autovacuum worker

2021-03-23 Thread Андрей Сычёв
Definition for the table fpbackup.fp_vpn_data_2021w12: CREATE TABLE fpbackup.fp_vpn_data_2021w12 ( id int8 NOT NULL DEFAULT nextval('fp_vpn_data_id_seq'::regclass), fp_date_start timestamp NOT NULL, fp_date_end timestamp NOT NULL, fp_host varchar NOT

Re: No enough privileges for autovacuum worker

2021-03-23 Thread Adrian Klaver
On 3/23/21 9:18 AM, Андрей Сычёв wrote: Sorry, my mistake, but actually trigrams_array is called by trigrams_vector Yes and that is at least one of the issues: 2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[(at)] ERROR: permission denied for schema dict at character

Re: No enough privileges for autovacuum worker

2021-03-23 Thread Adrian Klaver
On 3/23/21 9:07 AM, Андрей Сычёв wrote: Definition for the table fpbackup.fp_vpn_data_2021w12: CREATE TABLE fpbackup.fp_vpn_data_2021w12 ( id int8 NOT NULL DEFAULT nextval('fp_vpn_data_id_seq'::regclass), fp_date_start timestamp NOT NULL, fp_date_end timestamp NOT NUL

Re: No enough privileges for autovacuum worker

2021-03-23 Thread Adrian Klaver
On 3/23/21 3:20 AM, Андрей Сычёв wrote: Hi everyone, Every minute, I see the following error message in my server logs: 2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[@] ERROR: permission denied for schema dict at character 34 2021-03-23 13:00:07.564 MSK [60828]-[]-[]-

No enough privileges for autovacuum worker

2021-03-23 Thread Андрей Сычёв
Hi everyone, Every minute, I see the following error message in my server logs: 2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[@] ERROR: permission denied for schema dict at character 34 2021-03-23 13:00:07.564 MSK [60828]-[]-[]-[autovacuum worker]-[42501]-[@] QUERY: