pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Sean Murphy <Sean.Murphy@equipoint.com>
To: pgsql-admin@postgresql.org
Subject: How to compile with different MAXALIGN?
Date: Wed, 04 Apr 2007 14:28:11 -0700
Message-ID: <4614186B.2060101@equipoint.com> (raw)

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



view thread (8+ messages)  latest in thread

Message-ID: <4614186B.2060101@equipoint.com>
Permalink:  ../4614186B.2060101@equipoint.com/
Also on:    postgresql.org/message-id/4614186B.2060101@equipoint.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Sean.Murphy@equipoint.com
  Subject: Re: How to compile with different MAXALIGN?
  In-Reply-To: <4614186B.2060101@equipoint.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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