Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0832E2E010E for ; Mon, 26 Nov 2007 12:17:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 86723-06 for ; Mon, 26 Nov 2007 12:17:21 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id A5BFA2E00D8 for ; Mon, 26 Nov 2007 12:17:21 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lAQGH9qA002111 for ; Mon, 26 Nov 2007 12:17:09 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lAQG3pnX098769 for pgsql-admin@postgresql.org; Mon, 26 Nov 2007 12:03:51 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Migrating from 32 to 64 bit Date: Mon, 26 Nov 2007 11:01:44 -0500 Organization: cbbrowne Computing Inc Lines: 29 Message-ID: <60r6iddmhj.fsf@dba2.int.libertyrms.com> References: <4748B148.6050001@lncsa.com> <474971C0.3090503@theendofthetunnel.de> <8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.21 (linux) Cancel-Lock: sha1:Xxm7AjU0ZVKXqUXmJg2m7NAA3lo= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/219 X-Sequence-Number: 27462 montaseri@gmail.com ("Medi Montaseri") writes: > But theoretically speaking, 32 or 64-bit ness of the application (ie the postmaster server) should not influence the data types offered by a particular DB > version. That is the semantics of data types and cpu-arch (register width, big endian, little endian, sparc, mips, x86), etc ) offered by a particular DB > version should be orthogonal. > A practical example is when I first begin my business on a Mac, then I move the database to a Sun and then on to a mainframe.... That's well and fine, but the point is that when those (reasonably generic!) data types get compiled into code for a particular platform, with particular endianness and word size, how it is optimal to represent them will vary based on the characteristics of the platform. As a result, not only do you need different executable binaries each platform, but you also need different binary database structures on each platform. A conceptually mitigating factor should be that by the time you get around to changing platforms, there will likely be a Newer, Better, Major PostgreSQL version available. So you should be considering doing a migration from "old, slower, inferior version on the inferior platform" to the "better, stronger, faster version on the superior platform." With THAT context, the need to run initdb is further "given." -- output = ("cbbrowne" "@" "linuxdatabases.info") http://www3.sympatico.ca/cbbrowne/x.html "Have you noticed that, when we were young, we were told that `everybody else is doing it' was a really stupid reason to do something, but now it's the standard reason for picking a particular software package?" -- Barry Gehm