Thread: Database uptime?

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

Jeff Boes a écrit:
> 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.
>

you could write a perl script launched by cron which does some inserts
in an information table about the uptime etc...