Re: postgres uptime

On Fri, 20 Aug 2004, Gavin Sherry wrote:

>
> On Thu, 19 Aug 2004, Alvaro Herrera wrote:
>
>> On Fri, Aug 20, 2004 at 09:43:13AM +0800, Christopher Kings-Lynne wrote:
>>>> It seems that there is no way to know the postgres
>>>> uptime, a sort of uptime() function could be usefull.
>>>> I had recently the necessity of detect a node fail over,
>>>> and the only way I can do it with a SQL connection is asking
>>>> the engine uptime. Of course I can do it with PS but
>>>> now that windows version is out I believe a platform
>>>> indipendent way is required. Any objection to add it ?
>>>
>>> That sounds like a cool idea to me, although I would suggest a function
>>> pg_uptime() that returns an interval or something.
>>>
>>> However, adding a new function requires a re-initdb, so it's quite
>>> unlikely this will be in for 8.0.
>>
>> Is the uptime kept internally anywhere?  Or even the start time?
>
> We do this at the start of ServerLoop():
>
>    gettimeofday(&earlier, &tz);
>
> and that value isn't changed, AFAICT. However, I'm not sure why an uptime
> is all that useful?

Bragging rights? :)

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664