Обсуждение: Point in time recovery

Поиск
Список
Период
Сортировка

Point in time recovery

От
Karuna Karpe
Дата:
Hello,

         Can any one please explain me how to use PITR?

Regards,
karuna karpe.

Re: Point in time recovery

От
Simon Riggs
Дата:
On Wed, Nov 23, 2011 at 12:39 PM, Karuna Karpe
<karuna.karpe@os3infotech.com> wrote:

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

Yes, the docs contain a great explanation.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: Point in time recovery

От
Ian Lea
Дата:
>          Can any one please explain me how to use PITR?

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

--
Ian.

Re: Point in time recovery

От
Craig Ringer
Дата:
On 11/23/2011 08:39 PM, Karuna Karpe wrote:
Hello,

         Can any one please explain me how to use PITR?

Are you struggling with one particular issue with PITR setup where the documentation isn't helping? If so, please explain in more detail, making sure to include all the appropriate information about your setup.

See: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

If this is a more general question about how to use PITR and you haven't tried it yet, start with the manual here:

http://www.postgresql.org/docs/current/static/continuous-archiving.html
http://www.postgresql.org/docs/current/static/warm-standby.html

--
Craig Ringer

Re: Point in time recovery

От
"white.heron white"
Дата:
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