Received: from maia.hub.org (maia-1.hub.org [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 1A98D632735 for ; Wed, 5 May 2010 12:31:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 06341-08 for ; Wed, 5 May 2010 15:31:14 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og119.obsmtp.com (exprod7og119.obsmtp.com [64.18.2.16]) by mail.postgresql.org (Postfix) with SMTP id 1F0F8632509 for ; Wed, 5 May 2010 12:31:13 -0300 (ADT) Received: from source ([209.85.161.41]) by exprod7ob119.postini.com ([64.18.6.12]) with SMTP ID DSNKS+GPQcLNG9ezDIr5Bpg8Z1m9pXT3b8Ot@postini.com; Wed, 05 May 2010 08:31:14 PDT Received: by fxm1 with SMTP id 1so4499767fxm.28 for ; Wed, 05 May 2010 08:31:12 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.68.13 with SMTP id t13mr5546107fai.69.1273073472437; Wed, 05 May 2010 08:31:12 -0700 (PDT) Received: by 10.223.123.201 with HTTP; Wed, 5 May 2010 08:31:12 -0700 (PDT) In-Reply-To: References: Date: Wed, 5 May 2010 11:31:12 -0400 Message-ID: Subject: Re: PITR backup & Restore issue From: Scott Mead To: raghu ram Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=0015174be42e18fea80485da84cb X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.199 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201005/61 X-Sequence-Number: 34534 --0015174be42e18fea80485da84cb Content-Type: text/plain; charset=ISO-8859-1 On Wed, May 5, 2010 at 11:27 AM, raghu ram 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 --0015174be42e18fea80485da84cb Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

On Wed, May 5, 2010 at 11:27 AM, raghu ram <raghuchennuru@gmail.com<= /a>> 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 c= opying the physical files directly off the database server. The only way to= move from one platform / architecture to another is to use a 'logical&= #39; method vs. the physical copy involved with PITR.


--Scott
--0015174be42e18fea80485da84cb--