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 lifesp
Alvaro Herrera wrote:
> 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
>
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 co
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 u
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
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 lifesp
