Re: postgres uptime - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: postgres uptime
Date
Msg-id 4125C047.8060209@bigfoot.com
Whole thread Raw
In response to Re: postgres uptime  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

Even if the re-initdb was not necessary we are in beta, and usualy the
new features are not allowed.


Regards
Gaetano Mendola


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBJcBG7UpzwH2SGd4RAgj/AJ0ZldSnVca/OJ/WQhpkEnrYhi439gCgs4Uw
Rqv0nDE7O7APcT2qgDz2BPI=
=gyq5
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: tablespace and sequences?
Next
From: Gaetano Mendola
Date:
Subject: Re: postgres uptime