On Tue, Nov 1, 2016 at 1:43 PM, Patrick B wrote:
>
>
> 2016-11-02 2:55 GMT+13:00 Scott Marlowe :
>>
>> On Mon, Oct 31, 2016 at 8:01 PM, Patrick B
>> wrote:
>> > If I change recovery.conf:
>> >
>> > recovery_target_time
2016-11-02 8:43 GMT+13:00 Patrick B :
>
>
> 2016-11-02 2:55 GMT+13:00 Scott Marlowe :
>
>> On Mon, Oct 31, 2016 at 8:01 PM, Patrick B
>> wrote:
>> > If I change recovery.conf:
>> >
>> > recovery_target_time =
2016-11-02 2:55 GMT+13:00 Scott Marlowe :
> On Mon, Oct 31, 2016 at 8:01 PM, Patrick B
> wrote:
> > If I change recovery.conf:
> >
> > recovery_target_time = '2016-10-30 02:24:40'
> >
> >
> > I get error:
> >
> > FATAL: requested recovery stop
On Mon, Oct 31, 2016 at 8:01 PM, Patrick B wrote:
> If I change recovery.conf:
>
> recovery_target_time = '2016-10-30 02:24:40'
>
>
> I get error:
>
> FATAL: requested recovery stop point is before consistent recovery point
You can try using pg_basebackup to get the
Hi:
On Tue, Nov 1, 2016 at 3:01 AM, Patrick B wrote:
> If I change recovery.conf:
> recovery_target_time = '2016-10-30 02:24:40'
> I get error:
> FATAL: requested recovery stop point is before consistent recovery point
It looks clear. When you take a base backup from
If I change recovery.conf:
recovery_target_time = '2016-10-30 02:24:40'
I get error:
FATAL: requested recovery stop point is before consistent recovery point
I actually want to restore in a point of time.
Don't want to recovery_target_timeline = 'latest'
How can I stipulate a date?
Thanks
2016-11-01 11:59 GMT+13:00 Patrick B :
>
>
> 2016-11-01 10:33 GMT+13:00 David G. Johnston :
>
>> On Mon,
2016-11-01 10:33 GMT+13:00 David G. Johnston :
> On Mon, Oct 31, 2016 at 1:46 PM, Patrick B
> wrote:
>
>> Hi guys,
>>
>> I got a test server, let's call it test01.
>>
>> The test01 has a basebackup from the master.
>> I want to turn test01
On Mon, Oct 31, 2016 at 1:46 PM, Patrick B wrote:
> Hi guys,
>
> I got a test server, let's call it test01.
>
> The test01 has a basebackup from the master.
> I want to turn test01 into a master. It doesn't need to catch up with the
> wal_files, because I don't need it
Hi guys,
I got a test server, let's call it test01.
The test01 has a basebackup from the master.
I want to turn test01 into a master. It doesn't need to catch up with the
wal_files, because I don't need it to be up-to-date.
So what I did is:
- Replaced /var/lib/pgsql/9.2/data/ with the
10 matches
Mail list logo