Marc G. Fournier wrote: > 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? :) >
If we ever do SNMP stuff, it will be useful for those packets as well. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
