pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMigrating from 32 to 64 bit
8+ messages / 5 participants
[nested] [flat]
* Migrating from 32 to 64 bit
@ 2007-11-24 23:18 Laurent CARON <lcaron@lncsa.com>
2007-11-24 23:35 ` Re: Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
2007-11-25 12:59 ` Re: Migrating from 32 to 64 bit Hannes Dorbath <light@theendofthetunnel.de>
2007-11-25 13:00 ` Re: Migrating from 32 to 64 bit Hannes Dorbath <light@theendofthetunnel.de>
2007-11-26 15:25 ` Re: Migrating from 32 to 64 bit Vivek Khera <vivek@khera.org>
0 siblings, 4 replies; 8+ messages in thread
From: Laurent CARON @ 2007-11-24 23:18 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-admin
Hi,
I'm currently setting up 2 new servers to act as a PgSQL cluster (8.2).
This basically consists in the reinstallation of the OS (64Bit).
Question:
I'd like to know if it is possible (and wise) to just keep the
/var/lib/postgres...... directories from the old 32Bit server to use on
the 64Bit version.
This is just as a personal interest since I can also just dump and
restore the database in about 2.5 hrs.
Thanks
Laurent
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migrating from 32 to 64 bit
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
@ 2007-11-24 23:35 ` Laurent CARON <lcaron@lncsa.com>
3 siblings, 0 replies; 8+ messages in thread
From: Laurent CARON @ 2007-11-24 23:35 UTC (permalink / raw)
To: Douglas McNaught <doug@mcnaught.org>; +Cc: pgsql-general@postgresql.org
Douglas McNaught wrote:
> Nope, not possible--different architectures result in different data layouts.
>
> Dump & restore is the way to go.
>
Thanks,
I'll then dump/restore.
Laurent
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migrating from 32 to 64 bit
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
@ 2007-11-25 12:59 ` Hannes Dorbath <light@theendofthetunnel.de>
2007-11-26 05:24 ` Re: Migrating from 32 to 64 bit Medi Montaseri <montaseri@gmail.com>
3 siblings, 1 reply; 8+ messages in thread
From: Hannes Dorbath @ 2007-11-25 12:59 UTC (permalink / raw)
To: Laurent CARON <lcaron@lncsa.com>
Laurent CARON wrote:
> Question:
> I'd like to know if it is possible (and wise) to just keep the
> /var/lib/postgres...... directories from the old 32Bit server to use on
> the 64Bit version.
>
> This is just as a personal interest since I can also just dump and
> restore the database in about 2.5 hrs.
Dump and restore. Using the old data dirs won't work.
--
Best regards,
Hannes Dorbath
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migrating from 32 to 64 bit
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
2007-11-25 12:59 ` Re: Migrating from 32 to 64 bit Hannes Dorbath <light@theendofthetunnel.de>
@ 2007-11-26 05:24 ` Medi Montaseri <montaseri@gmail.com>
2007-11-26 16:01 ` Re: Migrating from 32 to 64 bit Chris Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 8+ messages in thread
From: Medi Montaseri @ 2007-11-26 05:24 UTC (permalink / raw)
To: Hannes Dorbath <light@theendofthetunnel.de>; +Cc: Laurent CARON <lcaron@lncsa.com>; pgsql-admin
But theoretically speaking, 32 or 64-bit ness of the application (ie the
postmaster server) should not influence the data types offered by a
particular DB version. That is the semantics of data types and cpu-arch
(register width, big endian, little endian, sparc, mips, x86), etc ) offered
by a particular DB version should be orthogonal.
A practical example is when I first begin my business on a Mac, then I move
the database to a Sun and then on to a mainframe....
Cheers
Medi
On Nov 25, 2007 4:59 AM, Hannes Dorbath <light@theendofthetunnel.de> wrote:
> Laurent CARON wrote:
> > Question:
> > I'd like to know if it is possible (and wise) to just keep the
> > /var/lib/postgres...... directories from the old 32Bit server to use on
> > the 64Bit version.
> >
> > This is just as a personal interest since I can also just dump and
> > restore the database in about 2.5 hrs.
>
> Dump and restore. Using the old data dirs won't work.
>
>
> --
> Best regards,
> Hannes Dorbath
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migrating from 32 to 64 bit
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
2007-11-25 12:59 ` Re: Migrating from 32 to 64 bit Hannes Dorbath <light@theendofthetunnel.de>
2007-11-26 05:24 ` Re: Migrating from 32 to 64 bit Medi Montaseri <montaseri@gmail.com>
@ 2007-11-26 16:01 ` Chris Browne <cbbrowne@acm.org>
2007-11-26 18:52 ` Re: Migrating from 32 to 64 bit Medi Montaseri <montaseri@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Chris Browne @ 2007-11-26 16:01 UTC (permalink / raw)
To: pgsql-admin
montaseri@gmail.com ("Medi Montaseri") writes:
> But theoretically speaking, 32 or 64-bit ness of the application (ie the postmaster server) should not influence the data types offered by a particular DB
> version. That is the semantics of data types and cpu-arch (register width, big endian, little endian, sparc, mips, x86), etc ) offered by a particular DB
> version should be orthogonal.
> A practical example is when I first begin my business on a Mac, then I move the database to a Sun and then on to a mainframe....
That's well and fine, but the point is that when those (reasonably
generic!) data types get compiled into code for a particular platform,
with particular endianness and word size, how it is optimal to
represent them will vary based on the characteristics of the platform.
As a result, not only do you need different executable binaries each
platform, but you also need different binary database structures on
each platform.
A conceptually mitigating factor should be that by the time you get
around to changing platforms, there will likely be a Newer, Better,
Major PostgreSQL version available. So you should be considering
doing a migration from "old, slower, inferior version on the inferior
platform" to the "better, stronger, faster version on the superior
platform." With THAT context, the need to run initdb is further
"given."
--
output = ("cbbrowne" "@" "linuxdatabases.info")
http://www3.sympatico.ca/cbbrowne/x.html
"Have you noticed that, when we were young, we were told that
`everybody else is doing it' was a really stupid reason to do
something, but now it's the standard reason for picking a particular
software package?" -- Barry Gehm
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migrating from 32 to 64 bit
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
2007-11-25 12:59 ` Re: Migrating from 32 to 64 bit Hannes Dorbath <light@theendofthetunnel.de>
2007-11-26 05:24 ` Re: Migrating from 32 to 64 bit Medi Montaseri <montaseri@gmail.com>
2007-11-26 16:01 ` Re: Migrating from 32 to 64 bit Chris Browne <cbbrowne@acm.org>
@ 2007-11-26 18:52 ` Medi Montaseri <montaseri@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Medi Montaseri @ 2007-11-26 18:52 UTC (permalink / raw)
To: Chris Browne <cbbrowne@acm.org>; +Cc: pgsql-admin
I agree with you practical points....I qualified my comments by
saying....theoretically speaking....
Cheers
Medi
On Nov 26, 2007 8:01 AM, Chris Browne <cbbrowne@acm.org> wrote:
> montaseri@gmail.com ("Medi Montaseri") writes:
> > But theoretically speaking, 32 or 64-bit ness of the application (ie the
> postmaster server) should not influence the data types offered by a
> particular DB
> > version. That is the semantics of data types and cpu-arch (register
> width, big endian, little endian, sparc, mips, x86), etc ) offered by a
> particular DB
> > version should be orthogonal.
> > A practical example is when I first begin my business on a Mac, then I
> move the database to a Sun and then on to a mainframe....
>
> That's well and fine, but the point is that when those (reasonably
> generic!) data types get compiled into code for a particular platform,
> with particular endianness and word size, how it is optimal to
> represent them will vary based on the characteristics of the platform.
>
> As a result, not only do you need different executable binaries each
> platform, but you also need different binary database structures on
> each platform.
>
> A conceptually mitigating factor should be that by the time you get
> around to changing platforms, there will likely be a Newer, Better,
> Major PostgreSQL version available. So you should be considering
> doing a migration from "old, slower, inferior version on the inferior
> platform" to the "better, stronger, faster version on the superior
> platform." With THAT context, the need to run initdb is further
> "given."
> --
> output = ("cbbrowne" "@" "linuxdatabases.info")
> http://www3.sympatico.ca/cbbrowne/x.html
> "Have you noticed that, when we were young, we were told that
> `everybody else is doing it' was a really stupid reason to do
> something, but now it's the standard reason for picking a particular
> software package?" -- Barry Gehm
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migrating from 32 to 64 bit
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
@ 2007-11-25 13:00 ` Hannes Dorbath <light@theendofthetunnel.de>
3 siblings, 0 replies; 8+ messages in thread
From: Hannes Dorbath @ 2007-11-25 13:00 UTC (permalink / raw)
To: Laurent CARON <lcaron@lncsa.com>
Laurent CARON wrote:
> Question:
> I'd like to know if it is possible (and wise) to just keep the
> /var/lib/postgres...... directories from the old 32Bit server to use on
> the 64Bit version.
>
> This is just as a personal interest since I can also just dump and
> restore the database in about 2.5 hrs.
Dump and restore. Using the old data dirs won't work.
--
Best regards,
Hannes Dorbath
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Migrating from 32 to 64 bit
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
@ 2007-11-26 15:25 ` Vivek Khera <vivek@khera.org>
3 siblings, 0 replies; 8+ messages in thread
From: Vivek Khera @ 2007-11-26 15:25 UTC (permalink / raw)
To: PgSQL General ML <pgsql-general@postgresql.org>
On Nov 24, 2007, at 6:18 PM, Laurent CARON wrote:
> Question:
> I'd like to know if it is possible (and wise) to just keep the
> /var/lib/postgres...... directories from the old 32Bit server to use
> on
> the 64Bit version.
>
> This is just as a personal interest since I can also just dump and
> restore the database in about 2.5 hrs.
No, you must dump/reload.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2007-11-26 18:52 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-24 23:18 Migrating from 32 to 64 bit Laurent CARON <lcaron@lncsa.com>
2007-11-24 23:35 ` Laurent CARON <lcaron@lncsa.com>
2007-11-25 12:59 ` Hannes Dorbath <light@theendofthetunnel.de>
2007-11-26 05:24 ` Medi Montaseri <montaseri@gmail.com>
2007-11-26 16:01 ` Chris Browne <cbbrowne@acm.org>
2007-11-26 18:52 ` Medi Montaseri <montaseri@gmail.com>
2007-11-25 13:00 ` Hannes Dorbath <light@theendofthetunnel.de>
2007-11-26 15:25 ` Vivek Khera <vivek@khera.org>
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