Re: Postmaster Uptime - Mailing list pgsql-general

From Tim Knowles
Subject Re: Postmaster Uptime
Date
Msg-id NGBBIAKALHHLLCHKLBONAEPJCAAA.tim@ametco.co.uk
Whole thread Raw
In response to Re: Postmaster Uptime  (Lee Kindness <lkindness@csl.co.uk>)
List pgsql-general
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@csl.co.uk]
Sent: 25 September 2002 10:39
To: Tim Knowles
Cc: Lee Kindness; pgsql-general@postgresql.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.


pgsql-general by date:

Previous
From: Lee Kindness
Date:
Subject: Re: Postmaster Uptime
Next
From: Ben Roberts
Date:
Subject: Re: problem with maintenance script and missing pg_clog files with pg 7.2.1