Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C77BC9FB44F for ; Wed, 4 Apr 2007 19:26:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31171-01 for ; Wed, 4 Apr 2007 19:26:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.equipoint.com (mail.equipoint.com [198.145.191.99]) by postgresql.org (Postfix) with ESMTP id C3F489FB39E for ; Wed, 4 Apr 2007 19:26:47 -0300 (ADT) Received: from [192.168.120.97] ([67.108.63.204]) by mail.equipoint.com (Merak 8.9.1) with ASMTP id JAE83645 for ; Wed, 04 Apr 2007 15:26:45 -0700 Message-ID: <46142625.9060204@equipoint.com> Date: Wed, 04 Apr 2007 15:26:45 -0700 From: Sean Murphy User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: How to compile with different MAXALIGN? References: <4614186B.2060101@equipoint.com> <46141C9B.9040708@mailnetwork.co.uk> <46141E40.1000109@equipoint.com> <46142126.1010402@mailnetwork.co.uk> In-Reply-To: <46142126.1010402@mailnetwork.co.uk> X-Enigmail-Version: 0.94.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/49 X-Sequence-Number: 25113 Actually the colo machine is running Windows as well (not my call, but there are other workloads on it) but Ubuntu is running under VMWare, so I could install a truly identical copy of the colo "machine" on the same server I'm moving from... Thanks! Andy Shellam wrote: > Is there any chance of you setting up a temporary machine on the same > network as your Windows one but an identical build as your co-located > machine? Then you can transfer your Windows data to Linux using > pg_dump/restore, switch your apps over to the Linux machine, then use > WAL files to mimic the changes onto your co-location. > > Once you're new co-lo machine is at the same stage as your temporary > one, switch the application over to your co-lo machine and turn the temp > and Windows machines off. > > Failing that perhaps someone with experience of Slony would be able > guide you if this is possible with Slony? > > Andy. > > Sean Murphy wrote: >> 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 >>>> >>>> >>>> >>>> >>>> >>> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 9: In versions below 8.0, the planner will ignore your desire to >> choose an index scan if your joining column's datatypes do not >> match >> >> !DSPAM:37,46141ebe89298265317040! >> >> >> > >