Re: How to tell how long server has been up? - Mailing list pgsql-admin

From Geoffrey
Subject Re: How to tell how long server has been up?
Date
Msg-id 4668313F.8070106@3times25.net
Whole thread Raw
In response to How to tell how long server has been up?  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
Chris Hoover wrote:
> 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.

I can think of a couple of ways...

ps aux|grep postmaster

ls -l postmaster.pid

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: warm standby database on 8.0.4
Next
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 and 8.4 feature list