Restore postgres to specific time

From: wd <wd(at)wdicc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Restore postgres to specific time
Date: 2012-11-22 11:28:54
Message-ID: CABexzmh8bycs7HBByNyk+HWwg7mrp9tJexTSsrAW2bRyqRRVxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-11-22 14:39:01 Re: Restore postgres to specific time
Previous Message Dave Page 2012-11-22 10:51:43 Re: Fw: Postgresql on Windows 8