Postgres Pro
Downloads
Home   >   mailing lists

Thread: Migrating from 32 bit to 64 bit binaries

Migrating from 32 bit to 64 bit binaries

From
Erik Jones
Date:
Just a quick question.  Are there any issues or incompatibilities
that I should be aware of if I want to build out 64 bit binaries to
run on a db that's previously been run by 32 bit binaries?

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

Re: Migrating from 32 bit to 64 bit binaries

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Erik Jones wrote:
> Just a quick question.  Are there any issues or incompatibilities that I
> should be aware of if I want to build out 64 bit binaries to run on a db
> that's previously been run by 32 bit binaries?

Its a dump reload.

Joshua D. Drake

>
> Erik Jones
>
> Software Developer | Emma®
> erik@myemma.com
> 800.595.4401 or 615.292.5888
> 615.292.0777 (fax)
>
> Emma helps organizations everywhere communicate & market in style.
> Visit us online at http://www.myemma.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG8/iLATb/zqfZUUQRAvloAKCe0l8evJ/+xTkwDu29fbC89ucCggCgjKcZ
uQmXLLy5YSct+QTVuz3rNtU=
=vyxW
-----END PGP SIGNATURE-----

Re: Migrating from 32 bit to 64 bit binaries

From
Alvaro Herrera
Date:
Erik Jones wrote:
> Just a quick question.  Are there any issues or incompatibilities that I
> should be aware of if I want to build out 64 bit binaries to run on a db
> that's previously been run by 32 bit binaries?

Obviously you are already aware that you need to dump/reload, so I won't
mention that.  Which makes this reply empty.  Hmmm.

--
Alvaro Herrera                          Developer, http://www.PostgreSQL.org/
"Changing the world ... one keyboard at a time!"
                         (www.DVzine.org)

Re: Migrating from 32 bit to 64 bit binaries

From
Erik Jones
Date:
On Sep 21, 2007, at 11:59 AM, Joshua D. Drake wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Erik Jones wrote:
>> Just a quick question.  Are there any issues or incompatibilities
>> that I
>> should be aware of if I want to build out 64 bit binaries to run
>> on a db
>> that's previously been run by 32 bit binaries?
>
> Its a dump reload.

Ouch, that's what I thought but was hoping someone would have some
magic formula and say it wasn't so.


Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

Re: Migrating from 32 bit to 64 bit binaries

From
Erik Jones
Date:
On Sep 21, 2007, at 12:02 PM, Alvaro Herrera wrote:

> Erik Jones wrote:
>> Just a quick question.  Are there any issues or incompatibilities
>> that I
>> should be aware of if I want to build out 64 bit binaries to run
>> on a db
>> that's previously been run by 32 bit binaries?
>
> Obviously you are already aware that you need to dump/reload, so I
> won't
> mention that.  Which makes this reply empty.  Hmmm.


Yeah, I did, I was just hoping I was wrong somehow :)

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com