Re: postgres uptime

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?

If it is, it would be quite trivial to provide access to it, and there
is at least one other thing to do "if we initdb" in the open items list
for 8.0.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)