PITR backup & Restore issue

--0016364edc18a1bdd40485da7686
Content-Type: text/plain; charset=ISO-8859-1

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

--0016364edc18a1bdd40485da7686
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Postgres Guru's,<div><br></div><div><br></div><div><p style=3D"margi=
n: 0.0px 0.0px 13.0px 0.0px; font: 13.0px Arial; color: #555555">Is it poss=
ible to use the Hot Backup (PITR Backup) of PostgreSQL on an Operating syst=
em to restore the database on other Operating system.</p>
<p style=3D"margin: 0.0px 0.0px 13.0px 0.0px; font: 13.0px Arial; color: #5=
55555"><br></p><p style=3D"margin: 0.0px 0.0px 13.0px 0.0px; font: 13.0px A=
rial; color: #555555">Thanks & Regards</p><p style=3D"margin: 0.0px 0.0=
px 13.0px 0.0px; font: 13.0px Arial; color: #555555">
Raghu</p></div>

--0016364edc18a1bdd40485da7686--
raghu ram [ Mi, 05 Mai 2010 17:27 ] [ ID #2040889 ]

Re: PITR backup & Restore issue

--0015174be42e18fea80485da84cb
Content-Type: text/plain; charset=ISO-8859-1

On Wed, May 5, 2010 at 11:27 AM, raghu ram <raghuchennuru [at] 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

--0015174be42e18fea80485da84cb
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<meta charset=3D"utf-8"><font class=3D"Apple-style-span" face=3D"verdana, a=
rial, helvetica, sans-serif" size=3D"3"><span class=3D"Apple-style-span" st=
yle=3D"font-size: 12px; line-height: 18px; -webkit-border-horizontal-spacin=
g: 1px; -webkit-border-vertical-spacing: 1px;"><br>
</span></font><br>On Wed, May 5, 2010 at 11:27 AM, raghu ram <span dir=3D"l=
tr"><<a href=3D"mailto:raghuchennuru [at] gmail.com">raghuchennuru [at] gmail.com<=
/a>></span> wrote:<br><div class=3D"gmail_quote"><blockquote class=3D"gm=
ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex;">
Hi Postgres Guru's,<div><br></div><div><br></div><div><p style=3D"margi=
n:0.0px 0.0px 13.0px 0.0px;font:13.0px Arial;color:#555555">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=3D"margin:0.0px 0.0px 13.0px 0.0px;font:13.0px Arial;color:#555555=
"><br></p></div></blockquote><div><span class=3D"Apple-style-span" style=3D=
"font-family: verdana, arial, helvetica, sans-serif; font-size: 12px; line-=
height: 18px; -webkit-border-horizontal-spacing: 1px; -webkit-border-vertic=
al-spacing: 1px; ">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.</span></div>
<div><span class=3D"Apple-style-span" style=3D"font-family: verdana, arial,=
helvetica, sans-serif; font-size: 12px; line-height: 18px; -webkit-border-=
horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; "><br></span=
></div>
<div><span class=3D"Apple-style-span" style=3D"font-family: verdana, arial,=
helvetica, sans-serif; font-size: 12px; line-height: 18px; -webkit-border-=
horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; ">--Scott</s=
pan></div>
</div>

--0015174be42e18fea80485da84cb--
Scott Mead [ Mi, 05 Mai 2010 17:31 ] [ ID #2040890 ]

Re: PITR backup & Restore issue

<!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] ma il.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
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
& 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 & Regards,
Vibhor Kumar
</pre>
</body>
</html>
Vibhor Kumar [ Mi, 05 Mai 2010 17:33 ] [ ID #2040891 ]

Re: PITR backup & Restore issue

--00c09fa2187b340b700485ed03c3
Content-Type: text/plain; charset=ISO-8859-1

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 [at] ca.afilias.info



On Wed, May 5, 2010 at 11:27 AM, raghu ram <raghuchennuru [at] 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
>

--00c09fa2187b340b700485ed03c3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

You other option is to use Slony. Create replica and in a short outage you =
can move master to replica.<br><br>Chirag Dave=A0 416-673-4102<br>Database =
Administrator, Afilias Canada Corp.<br><a href=3D"mailto:cdave [at] ca.afilias.i=
nfo">cdave [at] ca.afilias.info</a><br>
<br><br><br><div class=3D"gmail_quote">On Wed, May 5, 2010 at 11:27 AM, rag=
hu ram <span dir=3D"ltr"><<a href=3D"mailto:raghuchennuru [at] gmail.com">rag=
huchennuru [at] gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0p=
t 0.8ex; padding-left: 1ex;">
Hi Postgres Guru's,<div><br></div><div><br></div><div><p style=3D"margi=
n: 0px 0px 13px; font-family: Arial; font-style: normal; font-variant: norm=
al; font-weight: normal; font-size: 13px; line-height: normal; font-size-ad=
just: none; font-stretch: normal; color: rgb(85, 85, 85);">
Is it possible to use the Hot Backup (PITR Backup) of PostgreSQL on an Oper=
ating system to restore the database on other Operating system.</p>
<p style=3D"margin: 0px 0px 13px; font-family: Arial; font-style: normal; f=
ont-variant: normal; font-weight: normal; font-size: 13px; line-height: nor=
mal; font-size-adjust: none; font-stretch: normal; color: rgb(85, 85, 85);"=
>
<br></p><p style=3D"margin: 0px 0px 13px; font-family: Arial; font-style: n=
ormal; font-variant: normal; font-weight: normal; font-size: 13px; line-hei=
ght: normal; font-size-adjust: none; font-stretch: normal; color: rgb(85, 8=
5, 85);">
Thanks & Regards</p><p style=3D"margin: 0px 0px 13px; font-family: Aria=
l; font-style: normal; font-variant: normal; font-weight: normal; font-size=
: 13px; line-height: normal; font-size-adjust: none; font-stretch: normal; =
color: rgb(85, 85, 85);">

Raghu</p></div>
</blockquote></div><br>

--00c09fa2187b340b700485ed03c3--
Chirag Dave [ Do, 06 Mai 2010 15:35 ] [ ID #2040995 ]
Datenbanken » gmane.comp.db.postgresql.admin » PITR backup & Restore issue

Vorheriges Thema: 6 SCSI Disks RAID 10 x 2 SCSI DISKS RAID1 + 4 SCSI Disks RAID 10
Nächstes Thema: Table space grow big - PostgreSQL