From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Artem Tomyuk <admin(at)leboutique(dot)com> |
Cc: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: autovacuum on system catalog |
Date: | 2018-04-03 13:11:53 |
Message-ID: | CAECtzeXaW-TLUpoUi0So3HzSxjChkqsJoNg-7u=MeivHnbzycA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2018-04-03 14:23 GMT+02:00 Artem Tomyuk <admin(at)leboutique(dot)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(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gary Stainburn | 2018-04-06 08:15:25 | Fwd: [CentOS] Centos 7 LAPP setup Postgresql version and setup |
Previous Message | Artem Tomyuk | 2018-04-03 12:23:40 | Re: autovacuum on system catalog |