Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id F219D2E0043 for ; Thu, 5 Jun 2008 19:49:53 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47605-06 for ; Thu, 5 Jun 2008 19:49:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.228]) by developer.postgresql.org (Postfix) with ESMTP id 015312E003B for ; Thu, 5 Jun 2008 19:49:50 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so1023266rvf.43 for ; Thu, 05 Jun 2008 15:49:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=eP2lFtpIH2iQiWfG3Xk2x+b7fP3V1QXpTb8m7isWfnI=; b=ACW80ksQt6pfemx08Fnzh1MrUDTS9vnlZH6l9I29fC/7nhylgBNiwHYeMIGJqP9LRG 9KywSv36wKaY2d0vKnW0aOMDiEsJq00ngsc7M29Xz7AWTej9vfRKl7T4jIj6WAB9cgHc bUAtKQIUfGQSPo6IAda0sAOpZ57bybyA+L8zY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=M3oA5uU55yfjd6Kl0J1EnRbKCjUwp2Hzc+Glcu77ANt6hNA9lfW3/h9f4q72ZV4Pt0 aKPVroSSBVH7F5NpvDNInL1TUNueOMyla8gXypcccoL5RghULMYifGFVcS3cTPspz4ga JYkqioo6ZPcJOrfdsKt1NKV8EQtMQrPXi5L0I= Received: by 10.114.198.1 with SMTP id v1mr2329239waf.64.1212706189487; Thu, 05 Jun 2008 15:49:49 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Thu, 5 Jun 2008 15:49:49 -0700 (PDT) Message-ID: Date: Thu, 5 Jun 2008 16:49:49 -0600 From: "Scott Marlowe" To: "Kevin Grittner" Subject: Re: Is it possible to convert WAL's between architectures? Cc: "Alvaro Herrera" , pgsql-admin@postgresql.org, "Marcin Kasperski" In-Reply-To: <48482192.EE98.0025.0@wicourts.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <87wsl5s98y.fsf@softax.com.pl> <20080605151932.GE16502@alvh.no-ip.org> <48482192.EE98.0025.0@wicourts.gov> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/46 X-Sequence-Number: 29384 On Thu, Jun 5, 2008 at 4:27 PM, Kevin Grittner wrote: >>>> On Thu, Jun 5, 2008 at 5:18 PM, in message > , "Scott > Marlowe" > wrote: >> On Thu, Jun 5, 2008 at 9:19 AM, Alvaro Herrera >> wrote: >>> Marcin Kasperski wrote: >>>> >>>> As in the title - is it possible to convert WAL for another > architecture? >>>> >>>> (source database on Linux/i386, contemplating chances to restore >>>> backup on Linux/amd64) >>> >>> No. >> >> Technically it really IS possible, but I can't imagine investing the >> time to be able to do so. > > We did this by installing the 32 bit libraries and making a 32 bit > build which ran under the 64 bit OS. True. But that would only work on 64/32 split OSes where the chipsets have a 32 bit compatibility mode. You couldn't do that from i386 to sparc64 for instance.