Re: postgres uptime

Richard Huxton wrote:
> Tom Lane wrote:
>
>> "Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
>>
>>> Does anyone have any 'benefits' to implementing such a thing that we
>>> can list? The cons appear to be easy, what about pros?
>>
>>
>>
>> That's exactly what's bugging me --- I have not seen any particularly
>> strong defense of why we *should* have this function.
>>
>> Your suggestion in another mail of restricting it to superusers would
>> eliminate most or all of the security gripes I'm raising. Whether that
>> still leaves it useful to the original suggestor's purpose, I dunno...
>
>
> If you had a pressing need, couldn't you just hack the startup script(s)
> to insert a timestamp in a suitable table?
>
> Or am I missing something here (as usual)?

That's right, I'm not stuck with this problem I solved it with `ps`, I suggested
a global uptime function considering that postgres is not snmp capable and
for windows administrators is a bit more difficult retrieve this value.

Regards
Gaetano Mendola