Re: Database uptime? - Mailing list pgsql-general

From frbn
Subject Re: Database uptime?
Date
Msg-id 3D899126.9070004@efbs-seafrigo.fr
Whole thread Raw
In response to Database uptime?  (Jeff Boes <jboes@nexcerpt.com>)
List pgsql-general
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...



pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Re: IN vs EXIIST
Next
From: "Peter Alberer"
Date:
Subject: Adding "on delete cascade" after table creation ?