pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 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 14:13 Tom Lane <tgl@sss.pgh.pa.us> parent: Olivier Hubaut <olivier@scmbb.ulb.ac.be> 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