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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate

Reply via email to