Re: postgresql question - Mailing list pgsql-admin

From Tom Lane
Subject Re: postgresql question
Date
Msg-id 537.1295647421@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgresql question  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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 by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: postgresql question
Next
From: "John Lister"
Date:
Subject: Should autovacuum do a database wide vacuum near transaction limit?