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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-11-26 08:20:20 | Re: pg_start_backup without WAL archiving |
Previous Message | Jeff Larsen | 2007-11-26 00:56:30 | Re: postgres schema printer |
From | Date | Subject | |
---|---|---|---|
Next Message | Gerhard Wiesinger | 2007-11-26 06:23:43 | Re: Tools for dumping pg_xlog, pg_clog, etc? |
Previous Message | Jeff Larsen | 2007-11-26 00:56:30 | Re: postgres schema printer |