Re: postgres uptime

Richard Huxton wrote:
> Tom Lane wrote:
> 
>> "Marc G. Fournier" <scrappy@postgresql.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