pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
To: Sean Murphy <Sean.Murphy@equipoint.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to compile with different MAXALIGN?
Date: Wed, 04 Apr 2007 22:46:03 +0100
Message-ID: <46141C9B.9040708@mailnetwork.co.uk> (raw)
In-Reply-To: <4614186B.2060101@equipoint.com>
References: <4614186B.2060101@equipoint.com>

 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!
>
>
>   




view thread (8+ messages)  latest in thread

Message-ID: <46141C9B.9040708@mailnetwork.co.uk>
Permalink:  ../46141C9B.9040708@mailnetwork.co.uk/
Also on:    postgresql.org/message-id/46141C9B.9040708@mailnetwork.co.uk

 · 

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: andy.shellam-lists@mailnetwork.co.uk, Sean.Murphy@equipoint.com
  Subject: Re: How to compile with different MAXALIGN?
  In-Reply-To: <46141C9B.9040708@mailnetwork.co.uk>

* 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