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.
Chris
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
