Re: postgresql question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postgresql question
Дата
Msg-id 537.1295647421@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: postgresql question  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Dennis Hoffman <dennis.hoffman@seagate.com> wrote:
>> What can I do?

> I'd be tempted to write a script which was owned by root which
> calculated the size as desired, and grant sudo rights to merlin to
> execute that particular script as the user with rights.

Seems like a postgres-owned script would be safer.  But actually
I'd suggest using contrib/dbsize rather than doing any of this.
Those functions got integrated into the core eventually, but in
7.4 they're in contrib.

(Ob-comment-you-do-realize-how-obsolete-7.4-is-dont-you)

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: postgresql question
Следующее
От: "John Lister"
Дата:
Сообщение: Should autovacuum do a database wide vacuum near transaction limit?