From: Sean Murphy <Sean.Murphy@equipoint.com>
To: andy.shellam-lists@mailnetwork.co.uk
Cc: pgsql-admin@postgresql.org
Subject: Re: [Spam] Re: How to compile with different MAXALIGN?
Date: Wed, 04 Apr 2007 14:53:04 -0700
Message-ID: <46141E40.1000109@equipoint.com> (raw)
In-Reply-To: <46141C9B.9040708@mailnetwork.co.uk>
References: <4614186B.2060101@equipoint.com>
<46141C9B.9040708@mailnetwork.co.uk>
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!
>>
>>
>>
>
>
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, andy.shellam-lists@mailnetwork.co.uk
Subject: Re: [Spam] Re: How to compile with different MAXALIGN?
In-Reply-To: <46141E40.1000109@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