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