pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmigration of 7.4 to 8.1
9+ messages / 7 participants
[nested] [flat]
* migration of 7.4 to 8.1
@ 2008-03-12 05:27 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 9+ messages in thread
From: sathiya psql @ 2008-03-12 05:27 UTC (permalink / raw)
To: pgsql-admin
Is there any article describing the migration database from postgresql 7.4to
8.1
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
@ 2008-03-13 03:17 ` Robert Treat <xzilla@users.sourceforge.net>
2008-03-13 05:50 ` Re: migration of 7.4 to 8.1 Scott Marlowe <scott.marlowe@gmail.com>
2008-03-26 08:45 ` Re: migration of 7.4 to 8.1 Enrico <scotty@linuxtime.it>
0 siblings, 2 replies; 9+ messages in thread
From: Robert Treat @ 2008-03-13 03:17 UTC (permalink / raw)
To: pgsql-admin; +Cc: sathiya psql <sathiya.psql@gmail.com>
On Wednesday 12 March 2008 01:27, sathiya psql wrote:
> Is there any article describing the migration database from postgresql
> 7.4to 8.1
I don't know of any specific references, but the process is not fundementally
different from any other major version upgrade. You'll want to do a schema
only dump of your current database any load that into the 8.1 database. Once
you feel comfortable that this works ok, try a data only dump and load that
into the 8.1 server. Once you comfortable all that works, you're ready to
upgrade.
I will note that if you're planning to upgrade, I'd recommend going stright to
8.3. 8.1 is a few years old, and 8.3 provides a number of features and
improvement you'll benefit from. Unless you have a strong reason to do
otherwise, go to 8.3. HTH.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
@ 2008-03-13 05:50 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-03-13 05:56 ` Re: migration of 7.4 to 8.1 Joshua D. Drake <jd@commandprompt.com>
1 sibling, 1 reply; 9+ messages in thread
From: Scott Marlowe @ 2008-03-13 05:50 UTC (permalink / raw)
To: Robert Treat <xzilla@users.sourceforge.net>; +Cc: pgsql-admin@postgresql.org, "sathiya psql" <sathiya.psql@gmail.com>
On Wed, Mar 12, 2008 at 8:17 PM, Robert Treat
<xzilla@users.sourceforge.net> wrote:
> On Wednesday 12 March 2008 01:27, sathiya psql wrote:
> > Is there any article describing the migration database from postgresql
> > 7.4to 8.1
>
> I don't know of any specific references, but the process is not fundementally
> different from any other major version upgrade. You'll want to do a schema
> only dump of your current database any load that into the 8.1 database. Once
> you feel comfortable that this works ok, try a data only dump and load that
> into the 8.1 server. Once you comfortable all that works, you're ready to
> upgrade.
>
> I will note that if you're planning to upgrade, I'd recommend going stright to
> 8.3. 8.1 is a few years old, and 8.3 provides a number of features and
> improvement you'll benefit from. Unless you have a strong reason to do
> otherwise, go to 8.3. HTH.
And if the OP is worried about running too new a version of pgsql,
8.2.6 is very mature. But if he's got 6 or more months until he goes
live, which is common, I'd recommend going to 8.3 which will be well
polished by then.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
2008-03-13 05:50 ` Re: migration of 7.4 to 8.1 Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-03-13 05:56 ` Joshua D. Drake <jd@commandprompt.com>
2008-03-13 13:50 ` Re: migration of 7.4 to 8.1 Geoffrey <lists@serioustechnology.com>
0 siblings, 1 reply; 9+ messages in thread
From: Joshua D. Drake @ 2008-03-13 05:56 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Robert Treat <xzilla@users.sourceforge.net>; pgsql-admin@postgresql.org, "sathiya psql" <sathiya.psql@gmail.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, 12 Mar 2008 22:50:21 -0700
"Scott Marlowe" <scott.marlowe@gmail.com> wrote:
> And if the OP is worried about running too new a version of pgsql,
> 8.2.6 is very mature. But if he's got 6 or more months until he goes
> live, which is common, I'd recommend going to 8.3 which will be well
> polished by then.
>
I would avoid 8.3 without extensive testing. 8.2.6 is likely a better
shot a minimizing one off incompatibilities.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL political pundit | Mocker of Dolphins
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFH2MIYATb/zqfZUUQRAqeiAKCjPXAW3OJ0zSq2edapaCjGTg6vxwCdG9lm
BPmOR332+20LivOz6SE+FIE=
=0Sfu
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
2008-03-13 05:50 ` Re: migration of 7.4 to 8.1 Scott Marlowe <scott.marlowe@gmail.com>
2008-03-13 05:56 ` Re: migration of 7.4 to 8.1 Joshua D. Drake <jd@commandprompt.com>
@ 2008-03-13 13:50 ` Geoffrey <lists@serioustechnology.com>
2008-03-13 16:04 ` Re: migration of 7.4 to 8.1 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 9+ messages in thread
From: Geoffrey @ 2008-03-13 13:50 UTC (permalink / raw)
To: pgsql-admin
Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 12 Mar 2008 22:50:21 -0700
> "Scott Marlowe" <scott.marlowe@gmail.com> wrote:
>
>> And if the OP is worried about running too new a version of pgsql,
>> 8.2.6 is very mature. But if he's got 6 or more months until he goes
>> live, which is common, I'd recommend going to 8.3 which will be well
>> polished by then.
>>
>
> I would avoid 8.3 without extensive testing. 8.2.6 is likely a better
> shot a minimizing one off incompatibilities.
We are in a very similar situation in that we are looking to migrate
from 7.4 to 8.3. So seeing Scott's and Joshua's responses, I'm not sure
if we should go with 8.2 or 8.3.
Joshua, are you disagreeing with Scott, or are you simply stating that
if one is moving from 7.4 to 8.3, you should do extensive testing? We
do plan to do so, but I just want to make sure I understand your post.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
2008-03-13 05:50 ` Re: migration of 7.4 to 8.1 Scott Marlowe <scott.marlowe@gmail.com>
2008-03-13 05:56 ` Re: migration of 7.4 to 8.1 Joshua D. Drake <jd@commandprompt.com>
2008-03-13 13:50 ` Re: migration of 7.4 to 8.1 Geoffrey <lists@serioustechnology.com>
@ 2008-03-13 16:04 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-03-13 16:17 ` Re: migration of 7.4 to 8.1 Geoffrey <lists@serioustechnology.com>
2008-03-13 16:28 ` Re: migration of 7.4 to 8.1 Joshua D. Drake <jd@commandprompt.com>
0 siblings, 2 replies; 9+ messages in thread
From: Tom Lane @ 2008-03-13 16:04 UTC (permalink / raw)
To: Geoffrey <lists@serioustechnology.com>; +Cc: pgsql-admin
Geoffrey <lists@serioustechnology.com> writes:
> Joshua D. Drake wrote:
>> I would avoid 8.3 without extensive testing. 8.2.6 is likely a better
>> shot a minimizing one off incompatibilities.
> We are in a very similar situation in that we are looking to migrate
> from 7.4 to 8.3. So seeing Scott's and Joshua's responses, I'm not sure
> if we should go with 8.2 or 8.3.
7.4 to 8.2 isn't exactly a trivial jump either; there are enough
incompatibilities that could bite you if you don't test your
applications. I don't think JD's argument above holds water.
What does hold water is the observation that 8.3 is still at 8.3.0
(though not for much longer) and has certainly got more bugs today
than recent 8.2.x releases. That should equalize out by, say,
middle of the year. So if you intend to go to production in the
next month or two then 8.2.x is a safer bet. If your release
timeframe is a bit longer, then 8.3.x would be a good choice because
it will perform better and be supported longer. You'd want to be
sure you were on 8.3.latest before going live of course.
regards, tom lane
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
2008-03-13 05:50 ` Re: migration of 7.4 to 8.1 Scott Marlowe <scott.marlowe@gmail.com>
2008-03-13 05:56 ` Re: migration of 7.4 to 8.1 Joshua D. Drake <jd@commandprompt.com>
2008-03-13 13:50 ` Re: migration of 7.4 to 8.1 Geoffrey <lists@serioustechnology.com>
2008-03-13 16:04 ` Re: migration of 7.4 to 8.1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-03-13 16:17 ` Geoffrey <lists@serioustechnology.com>
1 sibling, 0 replies; 9+ messages in thread
From: Geoffrey @ 2008-03-13 16:17 UTC (permalink / raw)
To: pgsql-admin
Tom Lane wrote:
> Geoffrey <lists@serioustechnology.com> writes:
>> Joshua D. Drake wrote:
>>> I would avoid 8.3 without extensive testing. 8.2.6 is likely a better
>>> shot a minimizing one off incompatibilities.
>
>> We are in a very similar situation in that we are looking to migrate
>> from 7.4 to 8.3. So seeing Scott's and Joshua's responses, I'm not sure
>> if we should go with 8.2 or 8.3.
>
> 7.4 to 8.2 isn't exactly a trivial jump either; there are enough
> incompatibilities that could bite you if you don't test your
> applications. I don't think JD's argument above holds water.
> What does hold water is the observation that 8.3 is still at 8.3.0
> (though not for much longer) and has certainly got more bugs today
> than recent 8.2.x releases. That should equalize out by, say,
> middle of the year. So if you intend to go to production in the
> next month or two then 8.2.x is a safer bet. If your release
> timeframe is a bit longer, then 8.3.x would be a good choice because
> it will perform better and be supported longer. You'd want to be
> sure you were on 8.3.latest before going live of course.
Thanks Tom, that's the kind of feedback I was looking for. We know
we've got quite a bit of testing ahead of us with our move to 8.3, so I
suspect that by the time we go live, it will be 8.3.1 or more.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
2008-03-13 05:50 ` Re: migration of 7.4 to 8.1 Scott Marlowe <scott.marlowe@gmail.com>
2008-03-13 05:56 ` Re: migration of 7.4 to 8.1 Joshua D. Drake <jd@commandprompt.com>
2008-03-13 13:50 ` Re: migration of 7.4 to 8.1 Geoffrey <lists@serioustechnology.com>
2008-03-13 16:04 ` Re: migration of 7.4 to 8.1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-03-13 16:28 ` Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 9+ messages in thread
From: Joshua D. Drake @ 2008-03-13 16:28 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Geoffrey <lists@serioustechnology.com>; pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thu, 13 Mar 2008 12:04:27 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Geoffrey <lists@serioustechnology.com> writes:
> > Joshua D. Drake wrote:
> >> I would avoid 8.3 without extensive testing. 8.2.6 is likely a
> >> better shot a minimizing one off incompatibilities.
>
> > We are in a very similar situation in that we are looking to
> > migrate from 7.4 to 8.3. So seeing Scott's and Joshua's responses,
> > I'm not sure if we should go with 8.2 or 8.3.
>
> 7.4 to 8.2 isn't exactly a trivial jump either; there are enough
> incompatibilities that could bite you if you don't test your
> applications. I don't think JD's argument above holds water.
7.4 to 8.2 is not a small jump. You are correct Tom. However, as
someone who is actively in the field doing these migrations, I can tell
you that 7.4 to 8.2 is a smaller jump. If nothing else it will avoid
the casting issues which can be a large burden on a small to medium
shop to go through and fix.
8.3 changed a lot of things. We are still observing (in production) all
the changes that must be made procedurally to make it work correctly
(like the way autovacuum will just quit if it runs into a lock it
doesn't like).
> What does hold water is the observation that 8.3 is still at 8.3.0
> (though not for much longer) and has certainly got more bugs today
> than recent 8.2.x releases. That should equalize out by, say,
> middle of the year. So if you intend to go to production in the
> next month or two then 8.2.x is a safer bet. If your release
> timeframe is a bit longer, then 8.3.x would be a good choice because
> it will perform better and be supported longer. You'd want to be
> sure you were on 8.3.latest before going live of course.
If the have the time and resources to do extensive testing over the
course of the next 3-4 months, then yes I would agree that 8.3 is a
reasonable solution.
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL political pundit | Mocker of Dolphins
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFH2VYZATb/zqfZUUQRAjVbAJ9rbhWxTaLCH6gRI7cEkOpWZtzUFwCfX2un
v5qnuULJ4v+W7TVrEjhrM1w=
=7IMO
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: migration of 7.4 to 8.1
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Re: migration of 7.4 to 8.1 Robert Treat <xzilla@users.sourceforge.net>
@ 2008-03-26 08:45 ` Enrico <scotty@linuxtime.it>
1 sibling, 0 replies; 9+ messages in thread
From: Enrico @ 2008-03-26 08:45 UTC (permalink / raw)
To: pgsql-admin
On Wed, 12 Mar 2008 23:17:59 -0400
Robert Treat <xzilla@users.sourceforge.net> wrote:
> On Wednesday 12 March 2008 01:27, sathiya psql wrote:
> > Is there any article describing the migration database from
> > postgresql 7.4to 8.1
Some time ago I wrote :
http://www.enricopirozzi.info/index.php?/archives/36-Postgresql-dump-from-7x-to-8.x-version.html
I hope that it can help you :)
Regards
Enrico
--
One small feel for man, one giant ass for mankind (Dr. Gregory House)
Enrico Pirozzi
Web: http://www.enricopirozzi.info
E-Mail: info@enricopirozzi.info
Skype: sscotty71
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2008-03-26 08:45 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-12 05:27 migration of 7.4 to 8.1 sathiya psql <sathiya.psql@gmail.com>
2008-03-13 03:17 ` Robert Treat <xzilla@users.sourceforge.net>
2008-03-13 05:50 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-03-13 05:56 ` Joshua D. Drake <jd@commandprompt.com>
2008-03-13 13:50 ` Geoffrey <lists@serioustechnology.com>
2008-03-13 16:04 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-03-13 16:17 ` Geoffrey <lists@serioustechnology.com>
2008-03-13 16:28 ` Joshua D. Drake <jd@commandprompt.com>
2008-03-26 08:45 ` Enrico <scotty@linuxtime.it>
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