Postgres Pro
Downloads
Home   >   mailing lists

Database uptime? - Mailing list pgsql-general

From Jeff Boes
Subject Database uptime?
Date
Msg-id amaleq$30c8$1@news.hub.org
Whole thread Raw
List pgsql-general
Tree view 
Is there any way via SQL to determine how long the database has been up?
I realize I could determine this by identifying the PID associated with
the postmaster, but I need to do this remotely via a connection.

--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise

pgsql-general by date:

Previous
From: Jason Earl
Date:
Subject: Re: Getting list of columns in a table
Next
From: Bruce Momjian
Date:
Subject: Re: psql: \pset pager 'always'?