Re: how is pitr replay interruption time determined?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: how is pitr replay interruption time determined?
Date: 2007-08-28 22:49:56
Message-ID: 11206.1188341396@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> Yeh, we traced a problem with GIN indexes to this cause in early June;
> Teodor fixed it quickly in REL8_2_STABLE, but that won't be available
> until 8.2.5.

Thanks, that's what I missed finding ... Robert, do you have any GIN
indexes in this DB?

> I'd be happier with a log message to say
> ereport(DEBUG2,
> (errmsg("RM %d not safe to record restart point at %X/%X",
> rmid,
> checkPoint->redo.xlogid,
> checkPoint->redo.xrecoff)));
> to help trace such things in future.

As long as it's DEBUG2 or so, no objection here.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2007-08-28 23:13:07 Re: how is pitr replay interruption time determined?
Previous Message Simon Riggs 2007-08-28 22:44:29 Re: how is pitr replay interruption time determined?