Postgres Pro
Downloads
Home   >   mailing lists

Time of 'pg_ctl reload'. - Mailing list pgsql-general

From Alexi Gen
Subject Time of 'pg_ctl reload'.
Date
Msg-id 955336.64430.qm@web53306.mail.re2.yahoo.com
Whole thread Raw
Responses Re: Time of 'pg_ctl reload'.  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Tree view
Thank you Michael!

I have another question - related to this.
If I make changes to the postgresql.conf and then do a 'pg_ctl reload', how do I get the date & time of this event?

Cheers!
Alexi Gen


On Mon, Aug 18, 2008 at 03:53:32AM -0700, Alexi Gen wrote:
> Is there a table/view available from where I can check what time the cluster was started?
> Need this to calculate the uptime of the cluster.

In PostgreSQL 8.1 and later you can run these queries to get the start
time and uptime:

SELECT pg_postmaster_start_time();
SELECT now() - pg_postmaster_start_time();

--
Michael Fuhr

Send instant messages to your online friends http://uk.messenger.yahoo.com

pgsql-general by date:

Previous
From: Alexi Gen
Date:
Subject:
Next
From: Joao Ferreira gmail
Date:
Subject: negative values for vacuum threshold check !!!