Re: Point in time recovery

["white.heron white" <white.heron@xxxxxxxxx>]

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.heron@xxxxxxxxx

---

From: Ian Lea <ian.lea@xxxxxxxxx>
To: Karuna Karpe <karuna.karpe@xxxxxxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxx
Sent: Wednesday, November 23, 2011 11:51 PM
Subject: Re: 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin