From: | Sean Murphy <Sean(dot)Murphy(at)equipoint(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to compile with different MAXALIGN? |
Date: | 2007-04-04 21:28:11 |
Message-ID: | 4614186B.2060101@equipoint.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Frost | 2007-04-04 21:44:36 | Re: security question |
Previous Message | Jeff Frost | 2007-04-04 20:35:06 | Re: security question |