pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Medi Montaseri <montaseri@gmail.com>
To: Hannes Dorbath <light@theendofthetunnel.de>
Cc: Laurent CARON <lcaron@lncsa.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Migrating from 32 to 64 bit
Date: Sun, 25 Nov 2007 21:24:15 -0800
Message-ID: <8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com> (raw)
In-Reply-To: <474971C0.3090503@theendofthetunnel.de>
References: <4748B148.6050001@lncsa.com>
	<474971C0.3090503@theendofthetunnel.de>

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
>

view thread (8+ messages)  latest in thread

Message-ID: <8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com>
Permalink:  ../8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com/
Also on:    postgresql.org/message-id/8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com

 · 

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: montaseri@gmail.com, light@theendofthetunnel.de, lcaron@lncsa.com
  Subject: Re: Migrating from 32 to 64 bit
  In-Reply-To: <8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com>

* 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