Re: PITR backup & Restore issue

From: Gmail Account <vibhor(dot)aim(at)gmail(dot)com>
To: raghu ram <raghuchennuru(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PITR backup & Restore issue
Date: 2010-05-05 15:33:00
Message-ID: 4BE18FAC.2070303@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
On 05/05/10 8:57 PM, raghu ram wrote:
<blockquote
cite="mid:k2wd331f2ee1005050827l48b3c5bcmf1abcf339f8879fe(at)mail(dot)gmail(dot)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
Operating system to restore the database on other Operating system.</p>
<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>
<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
&amp; Regards</p>
<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</p>
</div>
</blockquote>
<font face="Courier New, Courier, monospace"><br>
Nope, Hot Backup (Online Backup) of PostgreSQL, on One OS/File System
is not compatible with the Other OS/FileSystem.<br>
<br>
</font>If you want to Move the Database from One OS/File System to
other OS/Filesystem then use pg_dump/pg_dumpall command to take the
backup of database.<br>
<br>
<pre class="moz-signature" cols="72">--
Thanks &amp; Regards,
Vibhor Kumar
</pre>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.0 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jason Tan Boon Teck 2010-05-05 15:48:02 Downgrading v8.4 database to v8.3
Previous Message Scott Mead 2010-05-05 15:31:12 Re: PITR backup & Restore issue