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