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@yahoo.com
From: Ian Lea <ian.lea@gmail.com>
To: Karuna Karpe <karuna.karpe@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