>>> Martin Badie <martinbadie@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
