pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddump/restore needed when switching from 32bit to 64bit processor architecture?
4+ messages / 3 participants
[nested] [flat]
* dump/restore needed when switching from 32bit to 64bit processor architecture?
@ 2005-07-19 09:03 Dirk Lutzebäck <lutzeb@aeccom.com>
2005-07-19 14:05 ` Re: dump/restore needed when switching from 32bit to 64bit processor architecture? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Dirk Lutzebäck @ 2005-07-19 09:03 UTC (permalink / raw)
To: pgsql-admin; +Cc: pgsql-general@postgresql.org
Hi,
when have a 8.0.3 database running on a XEON machine. We want to replace
it with an Opteron where postgresql is to be compiled with 64bit. Do we
need a dump/restore or can we just start the db with the new compilation?
Regards,
Dirk
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dump/restore needed when switching from 32bit to 64bit processor architecture?
2005-07-19 09:03 dump/restore needed when switching from 32bit to 64bit processor architecture? Dirk Lutzebäck <lutzeb@aeccom.com>
@ 2005-07-19 14:05 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-07-19 17:48 ` Re: dump/restore needed when switching from 32bit to 64bit Dirk Lutzebäck <lutzeb@aeccom.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2005-07-19 14:05 UTC (permalink / raw)
To: Dirk Lutzebäck <lutzeb@aeccom.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> when have a 8.0.3 database running on a XEON machine. We want to replace
> it with an Opteron where postgresql is to be compiled with 64bit. Do we
> need a dump/restore or can we just start the db with the new compilation?
I'd bet you need a dump/restore --- MAXALIGN is most likely different
on the two platforms. If it isn't, then maybe you could get away with
this, but it's definitely risky.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dump/restore needed when switching from 32bit to 64bit
2005-07-19 09:03 dump/restore needed when switching from 32bit to 64bit processor architecture? Dirk Lutzebäck <lutzeb@aeccom.com>
2005-07-19 14:05 ` Re: dump/restore needed when switching from 32bit to 64bit processor architecture? Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-07-19 17:48 ` Dirk Lutzebäck <lutzeb@aeccom.com>
2005-07-19 20:28 ` Re: dump/restore needed when switching from 32bit to 64bit Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 4+ messages in thread
From: Dirk Lutzebäck @ 2005-07-19 17:48 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin; pgsql-general@postgresql.org; sgeisler@aeccom.com
Thanks Tom,
we now stay with 32bit to allow backward compatibilty with XEON which is
needed as a fail-over system.
The question is which gcc cflags are best used with XEON and Opteron to
achieve fail-over compatibility. This is what we used for postgresql 8.0.3:
XEON, RHEL 3.0 AS:
CFLAGS = "-mcpu=pentium4 -march=pentium4"
Opteron 875, RHEL 3.0 AS, gcc version 3.2.3 20030502 (Red Hat Linux
3.2.3-42):
CFLAGS = "-Acpu=x86_64 -Amachine=x86_64"
Do we still need a dump/restore with this config?
Regards,
Dirk
Tom Lane wrote:
>=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
>
>
>>when have a 8.0.3 database running on a XEON machine. We want to replace
>>it with an Opteron where postgresql is to be compiled with 64bit. Do we
>>need a dump/restore or can we just start the db with the new compilation?
>>
>>
>
>I'd bet you need a dump/restore --- MAXALIGN is most likely different
>on the two platforms. If it isn't, then maybe you could get away with
>this, but it's definitely risky.
>
> regards, tom lane
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dump/restore needed when switching from 32bit to 64bit
2005-07-19 09:03 dump/restore needed when switching from 32bit to 64bit processor architecture? Dirk Lutzebäck <lutzeb@aeccom.com>
2005-07-19 14:05 ` Re: dump/restore needed when switching from 32bit to 64bit processor architecture? Tom Lane <tgl@sss.pgh.pa.us>
2005-07-19 17:48 ` Re: dump/restore needed when switching from 32bit to 64bit Dirk Lutzebäck <lutzeb@aeccom.com>
@ 2005-07-19 20:28 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2005-07-19 20:28 UTC (permalink / raw)
To: Dirk Lutzebäck <lutzeb@aeccom.com>; +Cc: pgsql-admin@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>; sgeisler@aeccom.com
Dirk Lutzebäck wrote:
> The question is which gcc cflags are best used with XEON and Opteron
> to achieve fail-over compatibility.
Configure both ways and run a diff over the generated pg_config.h files.
If there are differences, then there's a potential for trouble. (No
differences don't say there won't be trouble, but it'd be far less
likely.)
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-07-19 20:28 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-19 09:03 dump/restore needed when switching from 32bit to 64bit processor architecture? Dirk Lutzebäck <lutzeb@aeccom.com>
2005-07-19 14:05 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-07-19 17:48 ` Re: dump/restore needed when switching from 32bit to 64bit Dirk Lutzebäck <lutzeb@aeccom.com>
2005-07-19 20:28 ` Re: dump/restore needed when switching from 32bit to 64bit Peter Eisentraut <peter_e@gmx.net>
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