Re: Database uptime?

From: frbn <frbn(at)efbs-seafrigo(dot)fr>
To: Jeff Boes <jboes(at)nexcerpt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Database uptime?
Date: 2002-09-19 08:56:06
Message-ID: 3D899126.9070004@efbs-seafrigo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Alberer 2002-09-19 09:16:21 Adding "on delete cascade" after table creation ?
Previous Message Jean-Christian Imbeault 2002-09-19 08:43:40 Re: IN vs EXIIST