Re: Postmaster Uptime

Cheers for the link, I'll give pl/sh a go too. I was just hoping someone
else may have done it already.

Best Regards,

Tim

-----Original Message-----
From: Lee Kindness [mailto:lkindness(at)csl(dot)co(dot)uk]
Sent: 25 September 2002 10:39
To: Tim Knowles
Cc: Lee Kindness; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Postmaster Uptime

Lee Kindness writes:
> As others have said it is certainly do-able, but you're going to have
> to do it! In the past you've got the uptime using ps - what you need
> to do is wrap this into a script and add it to a database as a
> function (using pg/tcl, pg/perlu, whatever). Or you could do it as a C
> function...

Actually pl/sh would be the obvious choice:

http://www.ca.postgresql.org/~petere/plsh.html

Lee.