Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C122D9FB7A1 for ; Wed, 4 Apr 2007 18:40:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 26123-09 for ; Wed, 4 Apr 2007 18:40:33 -0300 (ADT) X-Greylist: delayed 00:12:22.713449 by SQLgrey-1.7.4 Received: from mail.equipoint.com (mail.equipoint.com [198.145.191.99]) by postgresql.org (Postfix) with ESMTP id ED9499FB704 for ; Wed, 4 Apr 2007 18:40:36 -0300 (ADT) Received: from [192.168.120.97] ([67.108.63.204]) by mail.equipoint.com (Merak 8.9.1) with ASMTP id JZG85211 for ; Wed, 04 Apr 2007 14:28:11 -0700 Message-ID: <4614186B.2060101@equipoint.com> Date: Wed, 04 Apr 2007 14:28:11 -0700 From: Sean Murphy User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How to compile with different MAXALIGN? 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/42 X-Sequence-Number: 25106 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