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.
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.
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
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных
