Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D294B9FC93A for ; Fri, 26 Oct 2007 06:54:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92611-05 for ; Fri, 26 Oct 2007 06:54:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.190]) by postgresql.org (Postfix) with ESMTP id 7C2449FC93F for ; Fri, 26 Oct 2007 06:54:15 -0300 (ADT) Received: by mu-out-0910.google.com with SMTP id i10so1283603mue for ; Fri, 26 Oct 2007 02:54:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=tUHuBFTow3txC/epw5r0bg82sAmYPkLn5ZxJvKQ+eu0=; b=ZFrpNsfGJ5HS8180EgjKVcvlWh+GZ/49lAuO6QL17i9o079ou5Lh/r/QI4Wp4JlY/c0tcsJnENIUSHlsHX5ITxqB/VDFkXiyiMXaMSbjXE6+AYKYhW+AP8HMCeHmHEjc0SAP814RjCkMCIOJ+WaJmIcf9StvWh4MwnaggaVTRl0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=izLObUBD/0DkABVT4PNjcVLVPowDwgEGTocpEDAWb6ArNlcmGbueirGXfuJbocifiuDTZD4PaT0Jide0O++wRIjm1zYEdOgXoZmivgAvXtDO0GqdBhYLz9NmCA0SSjoI8IzbMlLv5XWCZDB7tMHPtL8x3jJ6jm+lfIoUeFq9Jlw= Received: by 10.82.154.12 with SMTP id b12mr5697072bue.1193392453153; Fri, 26 Oct 2007 02:54:13 -0700 (PDT) Received: by 10.82.170.5 with HTTP; Fri, 26 Oct 2007 02:54:13 -0700 (PDT) Message-ID: <758d5e7f0710260254k53dec39fy32c7501f0ea310f9@mail.gmail.com> Date: Fri, 26 Oct 2007 11:54:13 +0200 From: "Dawid Kuroczko" Subject: Re: 32-bit to 64-bit migration screwup Cc: pgsql-admin@postgresql.org In-Reply-To: <1193379349.12268.14.camel@laptop.gunduz.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1193379349.12268.14.camel@laptop.gunduz.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/262 X-Sequence-Number: 27176 On 10/26/07, Devrim G=DCND=DCZ wrote: > Hi, > > On Thu, 2007-10-25 at 22:52 -0700, David Young wrote: > > FATAL: incorrect checksum in control file > > Did you move the old data files to the new server? If so, it won't work. > Dump your 32-bit database with 32-bit binaries, and load that data to > your 64-bit database. Not necessarily-- you can run old, 32bit environment under 64bit kernel (if you enabled 32-bit compatibility in kernel). Just run your old environ= ment in chroot. I have recently did such a migration (old 32bit system in chroot, pg_dump, pipe to psql on new system). Regards, Dawid