Re: postgres uptime

Added to TODO:
* Add a function that returns the 'uptime' of the postmaster

---------------------------------------------------------------------------

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?
> 
> 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)
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073