From: Shane Ambler <pgsql@Sheeky.Biz>
To: Martin Badie <martinbadie@yahoo.com>
Cc: pgsql <pgsql-admin@postgresql.org>
Subject: Re: 32bit data on 64bit machine?
Date: Tue, 21 Oct 2008 03:32:22 +1030
Message-ID: <48FCB99E.9000800@Sheeky.Biz> (raw)
In-Reply-To: <12366.76709.qm@web59904.mail.ac4.yahoo.com>
References: <12366.76709.qm@web59904.mail.ac4.yahoo.com>
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
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: pgsql@Sheeky.Biz, martinbadie@yahoo.com
Subject: Re: 32bit data on 64bit machine?
In-Reply-To: <48FCB99E.9000800@Sheeky.Biz>
* 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