Thread: PITR backup & Restore issue

PITR backup & Restore issue

From
raghu ram
Date:
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.


Thanks & Regards

Raghu

Re: PITR backup & Restore issue

From
Scott Mead
Date:


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

Re: PITR backup & Restore issue

From
Gmail Account
Date:
On 05/05/10 8:57 PM, raghu ram wrote: <blockquote
cite="mid:k2wd331f2ee1005050827l48b3c5bcmf1abcf339f8879fe@mail.gmail.com"type="cite">Hi Postgres Guru's, <div><br
/></div><div><br/></div><div><p style="margin: 0px 0px 13px; font-family: Arial; font-style: normal; font-variant:
normal;font-weight: normal; font-size: 13px; line-height: normal; font-size-adjust: none; font-stretch: normal;
-x-system-font:none; color: rgb(85, 85, 85);">Is it possible to use the Hot Backup (PITR Backup) of PostgreSQL on an
Operatingsystem to restore the database on other Operating system.<p style="margin: 0px 0px 13px; font-family: Arial;
font-style:normal; font-variant: normal; font-weight: normal; font-size: 13px; line-height: normal; font-size-adjust:
none;font-stretch: normal; -x-system-font: none; color: rgb(85, 85, 85);"><br /><p style="margin: 0px 0px 13px;
font-family:Arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 13px; line-height: normal;
font-size-adjust:none; font-stretch: normal; -x-system-font: none; color: rgb(85, 85, 85);">Thanks & Regards<p
style="margin:0px 0px 13px; font-family: Arial; font-style: normal; font-variant: normal; font-weight: normal;
font-size:13px; line-height: normal; font-size-adjust: none; font-stretch: normal; -x-system-font: none; color: rgb(85,
85,85);">Raghu</div></blockquote><font face="Courier New, Courier, monospace"><br /> Nope, Hot Backup (Online Backup)
ofPostgreSQL, on One OS/File System is not compatible with the Other OS/FileSystem.<br /><br /></font>If you want to
Movethe Database from One OS/File System to other OS/Filesystem then use pg_dump/pg_dumpall command to take the backup
ofdatabase.<br /><br /><pre class="moz-signature" cols="72">--  
Thanks & Regards,
Vibhor Kumar
</pre>

Re: PITR backup & Restore issue

From
Chirag Dave
Date:
You other option is to use Slony. Create replica and in a short outage you can move master to replica.

Chirag Dave  416-673-4102
Database Administrator, Afilias Canada Corp.
cdave@ca.afilias.info



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.


Thanks & Regards

Raghu