Обсуждение: Data directory transfert fails between PPC and x86

Поиск
Список
Период
Сортировка

Data directory transfert fails between PPC and x86

От
"Olivier Hubaut"
Дата:
Hi,

I used to make synchrnoistation between data directories with Rsync cause
it's faster when synchronizing offline database than making a dump.

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.

So, my question is, "Is there a way to make it works or am I obiged to use
dump files?"

--
Downloading signature ... 99%
*CRC FAILED*
signature aborted

Re: Data directory transfert fails between PPC and x86

От
Tom Lane
Дата:
"Olivier Hubaut" <olivier@scmbb.ulb.ac.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