Postgres Pro
Downloads
Home   >   mailing lists

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

From Benjamin Krajmalnik
Subject Re: How to tell how long server has been up?
Date
Msg-id F4E6A2751A2823418A21D4A160B6898807A53E@fletch.stackdump.local
Whole thread Raw
In response to How to tell how long server has been up?  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Dan Harris
Date:
Subject: reclaiming disk space after major updates
Next
From: Raul Retamozo
Date:
Subject: copying data into another database ? (replication)