Re: recovery_target_time and standby_mode

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: recovery_target_time and standby_mode
Date: 2014-11-06 01:39:30
Message-ID: 545AD152.7040304@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 11/05/2014 05:00 PM, Greg Stark wrote:
> On Thu, Nov 6, 2014 at 12:32 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> When the recovery_target_time is reached, switch to streaming
>> replication and stay a standby.
>
> Then shouldn't he just not specify a recovert_target at all? That's
> the default behaviour for standby_mode on, the whole point of
> recovery_target is to specify when to stop recovery and leave standby
> mode, no?
>

Their goal was to restore a master *and replica* to a point in time
before Bad Stuff happened, and then have a working master-replica pair.

Like I said, this is probably working as intended, we just need to
clarify it in the docs.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2014-11-06 01:41:43 Re: recovery_target_time and standby_mode
Previous Message Robert Haas 2014-11-06 01:38:36 Re: ltree::text not immutable?