Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Дата
Msg-id dcc563d11001300928s1ab6c725yd678a1937092a250@mail.gmail.com
обсуждение исходный текст
Ответ на VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it  (Ray Stell <stellr@cns.vt.edu>)
Ответы Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Список pgsql-admin
Дерево обсуждения 
On Sat, Jan 30, 2010 at 7:59 AM, Ray Stell <stellr@cns.vt.edu> wrote:
> Running 8.2.15 on RHEL4 the log reports this from autovacuum along with
> other pg_ tables:
>
> VACUUM WARNING:  skipping "pg_database" --- only table or database owner can vacuum it
>
> Any ideas how I can clean this up or how I got into this hole?
> Vacuum works as superuser.

Make yourself the owner of the database? (i.e. alter database ...)

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ray Stell
Дата:
Сообщение: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Следующее
От: Ray Stell
Дата:
Сообщение: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it