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

Re: pitr standby on slave with skewed time

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: pitr standby on slave with skewed time
Date: 2008-07-11 16:15:39
Message-ID: 6522.1215792939@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> Was review a clients config/setup and ran across a pitr warm standby scenario
> where the master machine is set to the current time, but the slave's time is 
> currently sitting back in the month of May. Outside of getting ntp setup on 
> the machine, I am wondering if I need to do anything special with the 
> postgresql setup, or if just setting the correct date on the machine is a 
> safe enough operation that nothing else would need to be done (like re-doing 
> the base backup). Any thoughts? 

AFAIR you should be all right ... PITR only looks at WAL indexes, not
file timestamps.

The slave does watch the current time to decide when to do recovery
restartpoints, so if you were setting the clock *back* by a large amount
it might be wise to stop and restart the slave postmaster.  Forward
should be no problem though.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Simon RiggsDate: 2008-07-11 17:15:57
Subject: Re: pitr standby on slave with skewed time
Previous:From: Robert TreatDate: 2008-07-11 15:19:45
Subject: pitr standby on slave with skewed time

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