pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed32bit data on 64bit machine?
3+ messages / 3 participants
[nested] [flat]
* 32bit data on 64bit machine?
@ 2008-10-20 12:22 Martin Badie <martinbadie@yahoo.com>
0 siblings, 2 replies; 3+ messages in thread
From: Martin Badie @ 2008-10-20 12:22 UTC (permalink / raw)
To: pgsql-admin
Hi,
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? Of course I am thinking to make a dump but I wanted to ask first because db is very huge (about 100 gb)
Regards?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 32bit data on 64bit machine?
@ 2008-10-20 16:44 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Martin Badie <martinbadie@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Kevin Grittner @ 2008-10-20 16:44 UTC (permalink / raw)
To: pgsql-admin; Martin Badie <martinbadie@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 32bit data on 64bit machine?
@ 2008-10-20 17:02 Shane Ambler <pgsql@Sheeky.Biz>
parent: Martin Badie <martinbadie@yahoo.com>
1 sibling, 0 replies; 3+ messages in thread
From: Shane Ambler @ 2008-10-20 17:02 UTC (permalink / raw)
To: Martin Badie <martinbadie@yahoo.com>; +Cc: pgsql-admin
Martin Badie wrote:
> Hi,
>
> 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? Of course I am thinking to make a dump but I wanted to ask
> first because db is very huge (about 100 gb)
The 32bit and 64bit will not read from the same data files.
You will need to dump and restore to transfer the data across.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-10-20 17:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-20 12:22 32bit data on 64bit machine? Martin Badie <martinbadie@yahoo.com>
2008-10-20 16:44 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2008-10-20 17:02 ` Shane Ambler <pgsql@Sheeky.Biz>
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