Re: production server down - Mailing list pgsql-hackers

From Tom Lane
Subject Re: production server down
Date
Msg-id 26976.1103088639@sss.pgh.pa.us
Whole thread Raw
In response to Re: production server down  (Joe Conway <mail@joeconway.com>)
Responses Re: production server down
List pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> Tom Lane wrote:
>> Please show the output of pg_controldata, or a hex dump of pg_control
>> if pg_controldata fails.

> OK, here it is:

> ...
> pg_control last modified:             Tue Dec 14 15:39:26 2004
> ...
> Time of latest checkpoint:            Tue Nov  2 17:05:32 2004

[ blink... ]  That seems like an unreasonable gap between checkpoints,
especially for a production server.  Can you see an explanation?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rémi Zara
Date:
Subject: Port report: NetBSD 2.0 mac68k
Next
From: strk@refractions.net
Date:
Subject: Re: join selectivity