PITR backup & Restore issue

am 05.05.2010 17:27:26 von raghu ram

--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,

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.

55555">

rial; color: #555555">Thanks & Regards

px 13.0px 0.0px; font: 13.0px Arial; color: #555555">
Raghu

--0016364edc18a1bdd40485da7686--

Re: PITR backup & Restore issue

am 05.05.2010 17:31:12 von Scott Mead

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

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

rial, helvetica, sans-serif" size=3D"3"> yle=3D"font-size: 12px; line-height: 18px; -webkit-border-horizontal-spacin=
g: 1px; -webkit-border-vertical-spacing: 1px;">

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

ail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-le=
ft:1ex;">
Hi Postgres Guru's,

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.

">

"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.

helvetica, sans-serif; font-size: 12px; line-height: 18px; -webkit-border-=
horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; ">
>

helvetica, sans-serif; font-size: 12px; line-height: 18px; -webkit-border-=
horizontal-spacing: 1px; -webkit-border-vertical-spacing: 1px; ">--Scott pan>

--0015174be42e18fea80485da84cb--

Re: PITR backup & Restore issue

am 05.05.2010 17:33:00 von Vibhor Kumar

On 05/05/10 8:57 PM, raghu ram wrote:
cite="mid:k2wd331f2ee1005050827l48b3c5bcmf1abcf339f8879fe@ma il.gmail.com"
type="cite">Hi Postgres Guru's,

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.

Nope, Hot Backup (Online Backup) of PostgreSQL, on One OS/File System
is not compatible with the Other OS/FileSystem.

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.

-- 

Thanks & Regards,

Vibhor Kumar

Re: PITR backup & Restore issue

am 06.05.2010 15:35:14 von Chirag Dave

--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@ca.afilias.info

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

Chirag Dave=A0 416-673-4102
Database =
Administrator, Afilias Canada Corp.
nfo">cdave@ca.afilias.info

On Wed, May 5, 2010 at 11:27 AM, rag=
hu ram <rag=
huchennuru@gmail.com> wrote:

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,

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.

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);"=
>

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
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

--00c09fa2187b340b700485ed03c3--