We're talking about 12 GB of data... to do the [probably ill-fated] binary copy in any reasonable amount of time required a portable hard drive and sneaker-net... That's why I'm anxious, probably to the point of stupidity, to avoid a situation where I'll have to bring the db down long enough to pull a backup dump onto portable media, drive to the colo, and restore it... (I'll do a pre-live test run of whatever procedure I go with, but...) Sean Andy Shellam wrote: > From experience I would say NEVER NEVER try and do a direct copy across > different platforms (Windows -> Linux.) > Someone may contradict me, but I think a dump/restore would be the way > to go. > > What sort of size of data are we talking? You'll need to factor in the > time it takes to dump the data, the time it takes to transfer the dump > to your new machine, and the time it takes to restore it. > > Andy. > > Sean Murphy wrote: >> I'm in the process of moving a large database from an in-house Win32 >> server to a co-located Ubuntu Linux server. The data's in constant use, >> so I can't really bring the server down for more than a half hour or so, >> and I'd like to go ahead and use a base backup + WAL restore strategy to >> sync the servers up before flipping the switch. >> >> After copying over my base backup and setting ACL appropriately, when I >> go to start the server on Linux it fails with a message in the log >> stating that the cluster (binary copy from the W32 server) is >> initialized MAXALIGN 8 and the server is compiled MAXALIGN 4. A search >> of the Docs tells me that I can compile the server with a different >> MAXALIGN, but the install docs don't give any indication how this is >> achieved. Is there a configure or gmake option I can feed, or do I need >> to change a line in one (or more) of the source files? >> >> Or is there a compelling reason (I'm absolutely ignorant here) to do a >> dump and restore instead of the binary copy because MAXALIGN 4 is better >> for performance/security/fill-in-the-blank? >> >> Or is a binary copy move from W to L hopeless even if this particular >> issue isn't? >> >> Thanks >> Sean >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 3: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq >> >> !DSPAM:37,46141bf689292106146716! >> >> >> > >
