Skip site navigation (1) Skip section navigation (2)

Re: how is pitr replay interruption time determined?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how is pitr replay interruption time determined?
Date: 2007-08-27 23:17:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> LOG:  database system was interrupted while in recovery at log time 2007-07-30 
> 19:17:37 EDT

> I am curious how this date is determined by postgres/pitr?

It's the update timestamp in pg_control, which in essence is going to be
the completion time of the last checkpoint.  If the crash was during WAL
recovery, as it seems to be, it'd be the time the last "restart"
checkpoint was made.

I'm not sure why the phrase "at log time" is used.  It looks like
whoever wrote the message thought that the timestamp would be one taken
from the WAL data being replayed, but that's not what I see the code

			regards, tom lane

In response to


pgsql-admin by date

Next:From: qinghuamail-postgresqlfansDate: 2007-08-28 02:15:24
Subject: 转发: Copy cmd error
Previous:From: Daniel MuñozDate: 2007-08-27 21:47:09
Subject: Re: Problems connecting to postgres using JDBC Driver.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group