Re: Point in time recovery

Dear All,

Point in Time Recovery in the context of computers is a system whereby a set of data or a particular setting can be restored or recovered from a time in the past.

- Windows XP's feature of being able to restore operating system settings from a past date (before data corruption occurred, for example).
- PostgreSQL's feature of being able to view a database table and its data as it was at a particular date in the past.
- Also, Time Machine for Mac OS X is an example of Point-in-time recovery.
 
 In PostgreSQL, Write-ahead logging (WAL) must be enabled for a particular database, in order for PITR to be used on that database; any time after WAL is enabled for a database, that database may be restored to any later time.

Regards,

MOHAMMAD ADLI BIN MT TAJUDIN
A8-2-7, DESA PANDAN APARTMENTS,
OFF JALAN KG. PANDAN,
55100 KUALA LUMPUR,
WEST MALAYSIA.

H/p number:  (017) 362 3661
Email: white(dot)heron(at)yahoo(dot)com

________________________________
From: Ian Lea <ian(dot)lea(at)gmail(dot)com>
To: Karuna Karpe <karuna(dot)karpe(at)os3infotech(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Sent: Wednesday, November 23, 2011 11:51 PM
Subject: Re: [ADMIN] Point in time recovery

>          Can any one please explain me how to use PITR?

http://lmgtfy.com/?q=postgres+pitr

--
Ian.