| Lists: | pgsql-hackers |
|---|
| From: | Jeff Trout <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Intel x64 vs AMD x64 pgdata |
| Date: | 2007-11-02 12:40:46 |
| Message-ID: | D1F11992-73A9-4198-AFFD-6CEF9E516A91@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hey folks,
Asking here since it may deal with clever things such as alignment
and or binary reps.
I'm migrating from some opterons to some xeons (E5345) both are
running x86_64. At first I figured I'd need to dump & load my data,
which will be painful. But on a whim I made a test db on the
opteron, copied it over (tar) and it fired up and worked fine on the
xeon. Seeing the success of this, I took our PITR backup and
restored it properly, and everything seems to be functioning
correctly from my tests.
Is there anything I should be weary of doing this? I'd figure any
alignment or other issues would have bitten me in my testing or PG
would simply refuse to start.
btw, the version in question is 8.2.5
thanks guys!
--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Intel x64 vs AMD x64 pgdata |
| Date: | 2007-11-02 15:17:34 |
| Message-ID: | 29641.1194016654@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com> writes:
> I'm migrating from some opterons to some xeons (E5345) both are
> running x86_64. At first I figured I'd need to dump & load my data,
> which will be painful. But on a whim I made a test db on the
> opteron, copied it over (tar) and it fired up and worked fine on the
> xeon. Seeing the success of this, I took our PITR backup and
> restored it properly, and everything seems to be functioning
> correctly from my tests.
Sure, those are the same architecture as far as PG is concerned.
regards, tom lane
| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Intel x64 vs AMD x64 pgdata |
| Date: | 2007-11-02 16:23:48 |
| Message-ID: | 20071102092348.2f5608f1@scratch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, 2 Nov 2007 08:40:46 -0400
Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com> wrote:
> Hey folks,
>
> Asking here since it may deal with clever things such as alignment
> and or binary reps.
>
> I'm migrating from some opterons to some xeons (E5345) both are
> running x86_64. At first I figured I'd need to dump & load my data,
> which will be painful. But on a whim I made a test db on the
> opteron, copied it over (tar) and it fired up and worked fine on the
> xeon. Seeing the success of this, I took our PITR backup and
> restored it properly, and everything seems to be functioning
> correctly from my tests.
x86_64 is x86_64, regardless of intel or amd.
Joshua D. Drake
- --
=== 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)
iD8DBQFHK08WATb/zqfZUUQRAtRcAKCoh0UqQJCfCbRltsfdqgaoPpa/SACePsRQ
t3/gNGb9/Lus6JaiVj3yhuA=
=6vs/
-----END PGP SIGNATURE-----
| From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Intel x64 vs AMD x64 pgdata |
| Date: | 2007-11-04 18:28:46 |
| Message-ID: | 472E0F5E.8060709@sun.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Joshua D. Drake wrote:
>
> x86_64 is x86_64, regardless of intel or amd.
Not exactly, ask kernel guys ;-). But for user space yes.
Zdenek
| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
| Cc: | Jeff Trout <threshar(at)threshar(dot)is-a-geek(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Intel x64 vs AMD x64 pgdata |
| Date: | 2007-11-04 18:38:52 |
| Message-ID: | 20071104103852.5be82d2a@scratch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Sun, 04 Nov 2007 19:28:46 +0100
Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> wrote:
> Joshua D. Drake wrote:
>
> >
> > x86_64 is x86_64, regardless of intel or amd.
>
> Not exactly, ask kernel guys ;-). But for user space yes.
For the context of the discussion...
Joshua D. Drake
>
> Zdenek
>
- --
=== 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)
iD8DBQFHLhG8ATb/zqfZUUQRAgwhAKCbpUKHy+1s8M+spvDrv93Lvw3xUgCffCR6
waU+dYx+RWCRBQBjFGUjvL8=
=q9jd
-----END PGP SIGNATURE-----