pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Data directory transfert fails between PPC and x86
2+ messages / 2 participants
[nested] [flat]

* Data directory transfert fails between PPC and x86
@ 2004-09-21 11:26 Olivier Hubaut <olivier@scmbb.ulb.ac.be>
  2004-09-21 14:13 ` Re: Data directory transfert fails between PPC and x86 Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Olivier Hubaut @ 2004-09-21 11:26 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Data directory transfert fails between PPC and x86
  2004-09-21 11:26 Data directory transfert fails between PPC and x86 Olivier Hubaut <olivier@scmbb.ulb.ac.be>
@ 2004-09-21 14:13 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-09-21 14:13 UTC (permalink / raw)
  To: Olivier Hubaut <olivier@scmbb.ulb.ac.be>; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-09-21 14:13 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-21 11:26 Data directory transfert fails between PPC and x86 Olivier Hubaut <olivier@scmbb.ulb.ac.be>
2004-09-21 14:13 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox