Re: Data directory transfert fails between PPC and x86

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Olivier Hubaut" <olivier(at)scmbb(dot)ulb(dot)ac(dot)be>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Data directory transfert fails between PPC and x86
Date: 2004-09-21 14:13:05
Message-ID: 507.1095775985@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Olivier Hubaut" <olivier(at)scmbb(dot)ulb(dot)ac(dot)be> writes:
> I used to make synchrnoistation between data directories with Rsync cause
> it's faster when synchronizing offline database than making a dump.

This has never been considered a supported technique. You can usually
get away with it if the source and destination machines are *exactly*
alike ... but if it breaks, you get to keep both pieces.

> It works really nice between all the PowerPC we used, but it doesn't work
> on x86 server (the postmaster refuses to start because the
> PG_CONTROL_VERSION is completly different). I think that the problem come
> from the endianess of the data structure.

Quite. In general the data files are platform-specific.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2004-09-21 20:47:32 Re: windows docs?
Previous Message Tom Lane 2004-09-21 14:10:50 Re: unable to add users