Skip site navigation (1) Skip section navigation (2)

Re: Migrating from 32 to 64 bit

From: "Medi Montaseri" <montaseri(at)gmail(dot)com>
To: "Hannes Dorbath" <light(at)theendofthetunnel(dot)de>
Cc: "Laurent CARON" <lcaron(at)lncsa(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Migrating from 32 to 64 bit
Date: 2007-11-26 05:24:15
Message-ID: 8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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(at)theendofthetunnel(dot)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
>

In response to

Responses

pgsql-admin by date

Next:From: Simon RiggsDate: 2007-11-26 08:20:20
Subject: Re: pg_start_backup without WAL archiving
Previous:From: Jeff LarsenDate: 2007-11-26 00:56:30
Subject: Re: postgres schema printer

pgsql-general by date

Next:From: Gerhard WiesingerDate: 2007-11-26 06:23:43
Subject: Re: Tools for dumping pg_xlog, pg_clog, etc?
Previous:From: Jeff LarsenDate: 2007-11-26 00:56:30
Subject: Re: postgres schema printer

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group