Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 07D3E2E0051 for ; Mon, 26 Nov 2007 01:24:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20174-01 for ; Mon, 26 Nov 2007 01:24:16 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 2F55F2E0032 for ; Mon, 26 Nov 2007 01:24:16 -0400 (AST) Received: by py-out-1112.google.com with SMTP id u77so1277672pyb for ; Sun, 25 Nov 2007 21:24:15 -0800 (PST) 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:references; bh=0gikqgocrkXVpLbc2bKuVukarC8fw8Qr0+gULphb4Jk=; b=fwAZo2uvRXYHkMr08LcM60MwNi5k/rwNxPYAKBDw6U1zW1lBvny14vwZXzSKVlC+v7H6TWdl0taSaSLxZWjTeVt7bxifX3t8+2HGFwf6tiSTz0IUYa8+QPi65tJ+DOrMwRI/OX7kJfuhuLJmleicOUX/ySAX8wB4OURFMk9lVpg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=jRKr8+VD+FH3qvqXtpici4AiV5wg7D00CNkk5XLrFHDBqSn4waU9WFZ6qJdSoRhX85AkR/hiyCzv1Sj7a11y7SbYUAsHbQAglo+zo8HM1Bwc4X5gvsOoVrO+HaCYuvcExcwkI7SWf+riEYYuYUj/frr7Et4IVNPV39G9U+Acr3k= Received: by 10.65.95.12 with SMTP id x12mr5031415qbl.1196054655169; Sun, 25 Nov 2007 21:24:15 -0800 (PST) Received: by 10.64.242.15 with HTTP; Sun, 25 Nov 2007 21:24:15 -0800 (PST) Message-ID: <8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com> Date: Sun, 25 Nov 2007 21:24:15 -0800 From: "Medi Montaseri" To: "Hannes Dorbath" Subject: Re: Migrating from 32 to 64 bit Cc: "Laurent CARON" , pgsql-admin@postgresql.org In-Reply-To: <474971C0.3090503@theendofthetunnel.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_37631_21088917.1196054655164" References: <4748B148.6050001@lncsa.com> <474971C0.3090503@theendofthetunnel.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/217 X-Sequence-Number: 27460 ------=_Part_37631_21088917.1196054655164 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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.... Cheers Medi On Nov 25, 2007 4:59 AM, Hannes Dorbath wrote: > Laurent CARON wrote: > > Question: > > I'd like to know if it is possible (and wise) to just keep the > > /var/lib/postgres...... directories from the old 32Bit server to use on > > the 64Bit version. > > > > This is just as a personal interest since I can also just dump and > > restore the database in about 2.5 hrs. > > Dump and restore. Using the old data dirs won't work. > > > -- > Best regards, > Hannes Dorbath > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > ------=_Part_37631_21088917.1196054655164 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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....

Cheers
Medi

On Nov 25, 2007 4:59 AM, Hannes Dorbath < light@theendofthetunnel.de> wrote:
Laurent CARON wrote:
> Question:
> I'd like to know if it is possible (and wise) to just keep the
> /var/lib/postgres...... directories from the old 32Bit server to use on
> the 64Bit version.
>
> This is just as a personal interest since I can also just dump and
> restore the database in about 2.5 hrs.

Dump and restore. Using the old data dirs won't work.


--
Best regards,
Hannes Dorbath

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

------=_Part_37631_21088917.1196054655164--