Re: Restore postgres to specific time

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "wd *EXTERN*" <wd(at)wdicc(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restore postgres to specific time
Date: 2012-11-22 14:39:01
Message-ID: D960CB61B694CF459DCFB4B0128514C208B888B4@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

wd wrote:
> I've try to restore Postgres to a specific time but failed.
>
> The recovery.conf as bellow
> restore_command='cp /t/xlog/%f %p'
> recovery_target_time='2012-11-22 5:01:09 CST'
> pause_at_recovery_target=true
> recovery_target_inclusive=false
>
> The basebackup was made at 2012-11-22 3:10 CST, I've copy wal log files at 3:00 to 5:10 into /t/xlog,
> but the recovery will not stop at 2012-11-22 5:01:09。
>
> How to do this?

Looks ok.
What does the server log say during the restore?

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rhys A.D. Stewart 2012-11-22 17:41:32 Re: get column name passed to a function
Previous Message wd 2012-11-22 11:28:54 Restore postgres to specific time