Обсуждение: How to tell how long server has been up?

Поиск
Список
Период
Сортировка

How to tell how long server has been up?

От
"Chris Hoover"
Дата:
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

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

От
"Benjamin Krajmalnik"
Дата:
select pg_postmaster_start_time()
 


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris Hoover
Sent: Wednesday, June 06, 2007 3:07 PM
To: pgsql-admin@postgresql.org Admin
Subject: [ADMIN] How to tell how long server has been up?

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

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

От
Geoffrey
Дата:
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