Re: 32bit data on 64bit machine?

>>> Martin Badie <martinbadie@yahoo.com> wrote:
> I have a 64 bit machine that has 32 bit pgsql rpms (8.2.5) installed.
If  I
> install 64 bit of the same version does that create any problems?

They can co-exist with no problem.  When you are running multiple
instances of PostgreSQL on the same box, you usually want to use
different port numbers.  If it's going to be a long-term thing, I
highly recommend a different OS user ID own the data directory for
each instance.  (I wouldn't do that just for a conversion, though.)

> Of course I am thinking to make a dump

Right.  We have been converting databases from 32-bit to 64-bit by
first updating the OS to 64 bit, then later using pg_dumpall piped to
psql on the same box.  It's been working great.

-Kevin