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

From Gmail Account
Subject Re: PITR backup & Restore issue
Date
Msg-id 4BE18FAC.2070303@gmail.com
Whole thread Raw
In response to PITR backup & Restore issue  (raghu ram <raghuchennuru@gmail.com>)
List pgsql-admin
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>

pgsql-admin by date:

Previous
From: Scott Mead
Date:
Subject: Re: PITR backup & Restore issue
Next
From: Jason Tan Boon Teck
Date:
Subject: Downgrading v8.4 database to v8.3