[CentOS] block level changes at the file system level?

Stephen Harris lists at spuddy.org
Thu Jul 3 20:47:30 UTC 2014


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



More information about the CentOS mailing list