How to tell how long server has been up?

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: How to tell how long server has been up?
Date: 2007-06-06 21:07:23
Message-ID: 1d219a6f0706061407l12a6f4dcka1e4affcf0d04cba@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Maybe I'm blind (wouldn't be the first time), but I can't see a way to find
out how long postgres has been running. Is there a way to tell this from a
query? I am working with some of the stat views and would like to correlate
them to how long the server has been running.

Thanks,

Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Harris 2007-06-06 21:41:53 troubleshooting "idle in transaction"
Previous Message Alvaro Herrera 2007-06-06 19:54:59 Re: 8.2.4 Won't Build 8.1 Functional Indexes