Re: production server down

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: production server down
Date: 2004-12-15 05:30:39
Message-ID: 26976.1103088639@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joe Conway <mail(at)joeconway(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2004-12-15 05:50:02 Re: production server down
Previous Message Joe Conway 2004-12-15 05:22:42 Re: production server down