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.he...@yahoo.com


________________________________
 From: Ian Lea <ian....@gmail.com>
To: Karuna Karpe <karuna.ka...@os3infotech.com> 
Cc: pgsql-admin@postgresql.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.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to