Re: postgres uptime - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: postgres uptime
Date
Msg-id 4125C5BD.9060302@bigfoot.com
Whole thread Raw
In response to Re: postgres uptime  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: postgres uptime
Next
From: ivan
Date:
Subject: select function & search_path problem/bug?