Re: PITR backup & Restore issue - Mailing list pgsql-admin

From Scott Mead
Subject Re: PITR backup & Restore issue
Date
Msg-id p2td3ab2ec81005050831z481066a8vdbe593c4728a667c@mail.gmail.com
Whole thread Raw
In response to PITR backup & Restore issue  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-admin


On Wed, May 5, 2010 at 11:27 AM, raghu ram <raghuchennuru@gmail.com> wrote:
Hi Postgres Guru's,


Is it possible to use the Hot Backup (PITR Backup) of PostgreSQL on an Operating system to restore the database on other Operating system.


No, it isn't. Physical (PITR) backups are based on copying the physical files directly off the database server. The only way to move from one platform / architecture to another is to use a 'logical' method vs. the physical copy involved with PITR.

--Scott

pgsql-admin by date:

Previous
From: raghu ram
Date:
Subject: PITR backup & Restore issue
Next
From: Gmail Account
Date:
Subject: Re: PITR backup & Restore issue