Обсуждение: autovacuum on system catalog

Поиск
Список
Период
Сортировка

autovacuum on system catalog

От
Artem Tomyuk
Дата:
Hi.

Why its not possible to set autovacuum settings on pg_attribute?

alter table pg_attribute set (autovacuum_vacuum_scale_factor = 0.0);
alter table pg_attribute set (autovacuum_vacuum_threshold = 500);

ERROR:  permission denied: "pg_attribute" is a system catalog
********** Ошибка **********

ERROR: permission denied: "pg_attribute" is a system catalog
SQL-состояние: 42501

Re: autovacuum on system catalog

От
Ron
Дата:
On 04/03/2018 07:16 AM, Artem Tomyuk wrote:
> Hi.
>
> Why its not possible to set autovacuum settings on pg_attribute?
>
> alter table pg_attribute set (autovacuum_vacuum_scale_factor = 0.0);
> alter table pg_attribute set (autovacuum_vacuum_threshold = 500);
>
> ERROR:  permission denied: "pg_attribute" is a system catalog
> ********** Ошибка **********
>
> ERROR: permission denied: "pg_attribute" is a system catalog
> SQL-состояние: 42501

I think you can only do that as superuser.

-- 
Angular momentum makes the world go 'round.

Re: autovacuum on system catalog

От
Artem Tomyuk
Дата:
I'am, trying to set it as built in postgres user.... Maybe there is no such feature to set autovac settings on system catalogs?

2018-04-03 15:21 GMT+03:00 Ron <ronljohnsonjr@gmail.com>:
On 04/03/2018 07:16 AM, Artem Tomyuk wrote:
Hi.

Why its not possible to set autovacuum settings on pg_attribute?

alter table pg_attribute set (autovacuum_vacuum_scale_factor = 0.0);
alter table pg_attribute set (autovacuum_vacuum_threshold = 500);

ERROR:  permission denied: "pg_attribute" is a system catalog
********** Ошибка **********

ERROR: permission denied: "pg_attribute" is a system catalog
SQL-состояние: 42501

I think you can only do that as superuser.

--
Angular momentum makes the world go 'round.


Re: autovacuum on system catalog

От
Guillaume Lelarge
Дата:
2018-04-03 14:23 GMT+02:00 Artem Tomyuk <admin@leboutique.com>:
I'am, trying to set it as built in postgres user.... Maybe there is no such feature to set autovac settings on system catalogs?


You cannot alter a system catalog. "Changing any part of a system catalog table is not permitted." (https://www.postgresql.org/docs/10/static/sql-altertable.html)

2018-04-03 15:21 GMT+03:00 Ron <ronljohnsonjr@gmail.com>:
On 04/03/2018 07:16 AM, Artem Tomyuk wrote:
Hi.

Why its not possible to set autovacuum settings on pg_attribute?

alter table pg_attribute set (autovacuum_vacuum_scale_factor = 0.0);
alter table pg_attribute set (autovacuum_vacuum_threshold = 500);

ERROR:  permission denied: "pg_attribute" is a system catalog
********** Ошибка **********

ERROR: permission denied: "pg_attribute" is a system catalog
SQL-состояние: 42501

I think you can only do that as superuser.

--
Angular momentum makes the world go 'round.





--
Guillaume.