Data directory transfert fails between PPC and x86

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

Data directory transfert fails between PPC and x86

От:
"Olivier Hubaut" <olivier@scmbb.ulb.ac.be>
Дата:
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 <tgl@sss.pgh.pa.us>
Дата:
"Olivier Hubaut"  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
FAQ