adey [EMAIL PROTECTED] writes:
Please let me know if there is a way to determine when the Postmaster was
last restarted?
The last postmaster start time, or the last database reset? These are
not the same if any backends have crashed since the postmaster started.
For determining stats lifespan
On Wed, Sep 07, 2005 at 09:22:55PM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Wed, Sep 07, 2005 at 12:38:44AM -0500, Jim C. Nasby wrote:
Is it too late to add a function that returns last reset time as well?
That would cover all bases and force some less confusing
On Wed, Sep 07, 2005 at 12:38:44AM -0500, Jim C. Nasby wrote:
On Tue, Sep 06, 2005 at 08:22:34PM -0400, Tom Lane wrote:
PG 8.1 will have a function to return postmaster start time, but not
database reset time. I wonder if this is misdefined --- if you are
trying to measure database uptime,
adey [EMAIL PROTECTED] writes:
Please let me know if there is a way to determine when the Postmaster was
last restarted?
The last postmaster start time, or the last database reset? These are
not the same if any backends have crashed since the postmaster started.
For determining stats lifespan
On Tue, Sep 06, 2005 at 08:22:34PM -0400, Tom Lane wrote:
PG 8.1 will have a function to return postmaster start time, but not
database reset time. I wonder if this is misdefined --- if you are
trying to measure database uptime, the last reset would be more
appropriate to track.
Is it too
