From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql <pgsql-admin@postgresql.org>
To: Martin Badie <martinbadie@yahoo.com>
Subject: Re: 32bit data on 64bit machine?
Date: Mon, 20 Oct 2008 11:44:39 -0500
Message-ID: <48FC6F27.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <12366.76709.qm@web59904.mail.ac4.yahoo.com>
References: <12366.76709.qm@web59904.mail.ac4.yahoo.com>
>>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, martinbadie@yahoo.com
Subject: Re: 32bit data on 64bit machine?
In-Reply-To: <48FC6F27.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox