Thread: PITR backup & Restore issue

Hi Postgres Guru's,

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

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>

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