Re: No enough privileges for autovacuum worker

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.fp_vpn_data_2021w12 USING gin (dict.trigrams_vector((fp_host)::text));

Aah, I missed that.

>
> As I know there is no explicit call for dict.trigrams_vector by me or
> anyone else.

The error is happening when the auto analyze opens the index on the
table, though I will have to admit that I don't know why?

What happens if you do a manual ANALYZE on the table?

>
> From the database logs I cannot figure out what user is responsible for
> calling this function as user field in the log in ordinary situation should be, for example, [user(at)dbname],
> not [(at)]
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com