Re: block level changes at the file system level?

Stephen Harris <lists@xxxxxxxxxx> · Thu, 3 Jul 2014 16:47:30 -0400



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-postgresql-9-2-pitr-3/

  #recovery_target_time = ''      # e.g. '2004-07-14 22:39:00 EST'

-- 

rgds
Stephen
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos