Обсуждение: autovacuum on system catalog
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
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.
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>:
I think you can only do that as superuser.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
--
Angular momentum makes the world go 'round.
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>:I think you can only do that as superuser.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
--
Angular momentum makes the world go 'round.
--
Guillaume.