pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedautovacuum on system catalog
4+ messages / 3 participants
[nested] [flat]
* autovacuum on system catalog
@ 2018-04-03 12:16 Artem Tomyuk <admin@leboutique.com>
2018-04-03 12:21 ` Re: autovacuum on system catalog Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Artem Tomyuk @ 2018-04-03 12:16 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: autovacuum on system catalog
2018-04-03 12:16 autovacuum on system catalog Artem Tomyuk <admin@leboutique.com>
@ 2018-04-03 12:21 ` Ron <ronljohnsonjr@gmail.com>
2018-04-03 12:23 ` Re: autovacuum on system catalog Artem Tomyuk <admin@leboutique.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ron @ 2018-04-03 12:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: autovacuum on system catalog
2018-04-03 12:16 autovacuum on system catalog Artem Tomyuk <admin@leboutique.com>
2018-04-03 12:21 ` Re: autovacuum on system catalog Ron <ronljohnsonjr@gmail.com>
@ 2018-04-03 12:23 ` Artem Tomyuk <admin@leboutique.com>
2018-04-03 13:11 ` Re: autovacuum on system catalog Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 4+ messages in thread
From: Artem Tomyuk @ 2018-04-03 12:23 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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.
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: autovacuum on system catalog
2018-04-03 12:16 autovacuum on system catalog Artem Tomyuk <admin@leboutique.com>
2018-04-03 12:21 ` Re: autovacuum on system catalog Ron <ronljohnsonjr@gmail.com>
2018-04-03 12:23 ` Re: autovacuum on system catalog Artem Tomyuk <admin@leboutique.com>
@ 2018-04-03 13:11 ` Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 4+ messages in thread
From: Guillaume Lelarge @ 2018-04-03 13:11 UTC (permalink / raw)
To: Artem Tomyuk <admin@leboutique.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-04-03 13:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-04-03 12:16 autovacuum on system catalog Artem Tomyuk <admin@leboutique.com>
2018-04-03 12:21 ` Ron <ronljohnsonjr@gmail.com>
2018-04-03 12:23 ` Artem Tomyuk <admin@leboutique.com>
2018-04-03 13:11 ` Guillaume Lelarge <guillaume@lelarge.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox