Re: How to tell how long server has been up?

From: Geoffrey <esoteric(at)3times25(dot)net>
To: "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to tell how long server has been up?
Date: 2007-06-07 16:24:31
Message-ID: 4668313F.8070106@3times25.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2007-06-07 16:40:37 Re: 8.3 and 8.4 feature list
Previous Message Tom Lane 2007-06-07 13:55:59 Re: warm standby database on 8.0.4