3 Jul
2014
3 Jul
'14
8:47 p.m.
On Thu, Jul 03, 2014 at 12:48:34PM -0700, Lists wrote:
Whatever we do, we need the ability to create a point-in-time history. We commonly use our archival dumps for audit, testing, and debugging purposes. I don't think PG + WAL provides this type of capability. So at the moment we're down to:
You can recover WAL files up until the point in time specified in the restore file
See, for example
http://opensourcedbms.com/dbms/how-to-do-point-in-time-recovery-with-postgre...
#recovery_target_time = '' # e.g. '2004-07-14 22:39:00 EST'
--
rgds
Stephen