pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feednewer release branch
7+ messages / 5 participants
[nested] [flat]
* newer release branch
@ 2010-10-06 15:03 Marc Fromm <Marc.Fromm@wwu.edu>
2010-10-06 15:57 ` Re: newer release branch Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-10-07 00:34 ` Re: newer release branch Greg Smith <greg@2ndquadrant.com>
0 siblings, 2 replies; 7+ messages in thread
From: Marc Fromm @ 2010-10-06 15:03 UTC (permalink / raw)
To: pgsql-admin
I was checking the details to an update to postgresql 8.1 and the following message was on the release notes page:
"The PostgreSQL community will stop releasing updates for the 8.1.X release series in November 2010. Users are encouraged to update to a newer release branch soon."
There were no links or other helpful information provided. Has anyone upgraded from 8.1 to the latest version 9.0.1? Can you do it in one jump?
Can it be done using yum on a RHEL server?
Thanks
Marc
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: newer release branch
2010-10-06 15:03 newer release branch Marc Fromm <Marc.Fromm@wwu.edu>
@ 2010-10-06 15:57 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-10-06 20:28 ` Re: newer release branch Devrim GÜNDÜZ <devrim@gunduz.org>
1 sibling, 1 reply; 7+ messages in thread
From: Kevin Grittner @ 2010-10-06 15:57 UTC (permalink / raw)
To: pgsql-admin; Marc Fromm <Marc.Fromm@wwu.edu>
Marc Fromm <Marc.Fromm@wwu.edu> wrote:
> Has anyone upgraded from 8.1 to the latest version 9.0.1? Can you
> do it in one jump?
I would expect it to work if you use pg_dump from the newer version
against the old database. The biggest compatibility issue is
probably going to be that in 8.3 some automatic casts to and from
text were eliminated. You would definitely want to do a preliminary
conversion and test your applications before doing the final
conversion.
> Can it be done using yum on a RHEL server?
You will probably need both 8.1 and 9.0 installed at the same time.
I don't know if yum will overwrite the old version or put the new
one in its own location without disturbing the old one.
-Kevin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: newer release branch
2010-10-06 15:03 newer release branch Marc Fromm <Marc.Fromm@wwu.edu>
2010-10-06 15:57 ` Re: newer release branch Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2010-10-06 20:28 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-06 22:02 ` Re: newer release branch Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Devrim GÜNDÜZ @ 2010-10-06 20:28 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin; Marc Fromm <Marc.Fromm@wwu.edu>
On Wed, 2010-10-06 at 10:57 -0500, Kevin Grittner wrote:
>
> > Can it be done using yum on a RHEL server?
>
> You will probably need both 8.1 and 9.0 installed at the same time.
> I don't know if yum will overwrite the old version or put the new
> one in its own location without disturbing the old one.
9.0 can be installed in parallel with yum, however still a dump/restore
or replication/failover type thing is needed, since 8.1 is not supported
by pg_upgrade.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: newer release branch
2010-10-06 15:03 newer release branch Marc Fromm <Marc.Fromm@wwu.edu>
2010-10-06 15:57 ` Re: newer release branch Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-10-06 20:28 ` Re: newer release branch Devrim GÜNDÜZ <devrim@gunduz.org>
@ 2010-10-06 22:02 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-10-07 04:43 ` Re: newer release branch Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 1 reply; 7+ messages in thread
From: Scott Marlowe @ 2010-10-06 22:02 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin; Marc Fromm <Marc.Fromm@wwu.edu>
2010/10/6 Devrim GÜNDÜZ <devrim@gunduz.org>:
> On Wed, 2010-10-06 at 10:57 -0500, Kevin Grittner wrote:
>>
>> > Can it be done using yum on a RHEL server?
>>
>> You will probably need both 8.1 and 9.0 installed at the same time.
>> I don't know if yum will overwrite the old version or put the new
>> one in its own location without disturbing the old one.
>
> 9.0 can be installed in parallel with yum, however still a dump/restore
> or replication/failover type thing is needed, since 8.1 is not supported
> by pg_upgrade.
Really? I've gotten apt based systems to run > 1 pg versions with
packages, but never rpm based. Especially not Centos or RHEL. Has
Fedora / yum started aachieved that?
I'd build a test server running 9.0.1 and test backing up from 8.0.x
and restoring to 9.0.1 before I did anything else, and then see how my
app worked.
Look out for missing type conversions.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: newer release branch
2010-10-06 15:03 newer release branch Marc Fromm <Marc.Fromm@wwu.edu>
2010-10-06 15:57 ` Re: newer release branch Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-10-06 20:28 ` Re: newer release branch Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-06 22:02 ` Re: newer release branch Scott Marlowe <scott.marlowe@gmail.com>
@ 2010-10-07 04:43 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-07 07:27 ` Re: newer release branch Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Devrim GÜNDÜZ @ 2010-10-07 04:43 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin; Marc Fromm <Marc.Fromm@wwu.edu>
On Wed, 2010-10-06 at 16:02 -0600, Scott Marlowe wrote:
> > 9.0 can be installed in parallel with yum, however still a
> > dump/restore or replication/failover type thing is needed, since 8.1
> > is not supported by pg_upgrade.
>
> Really? I've gotten apt based systems to run > 1 pg versions with
> packages, but never rpm based. Especially not Centos or RHEL. Has
> Fedora / yum started aachieved that?
http://people.planetpostgresql.org/devrim/index.php?/archives/48-What-is-new-in-PostgreSQL-9.0-RPMs....
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: newer release branch
2010-10-06 15:03 newer release branch Marc Fromm <Marc.Fromm@wwu.edu>
2010-10-06 15:57 ` Re: newer release branch Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-10-06 20:28 ` Re: newer release branch Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-06 22:02 ` Re: newer release branch Scott Marlowe <scott.marlowe@gmail.com>
2010-10-07 04:43 ` Re: newer release branch Devrim GÜNDÜZ <devrim@gunduz.org>
@ 2010-10-07 07:27 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Scott Marlowe @ 2010-10-07 07:27 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin; Marc Fromm <Marc.Fromm@wwu.edu>
2010/10/6 Devrim GÜNDÜZ <devrim@gunduz.org>:
> On Wed, 2010-10-06 at 16:02 -0600, Scott Marlowe wrote:
>
>> > 9.0 can be installed in parallel with yum, however still a
>> > dump/restore or replication/failover type thing is needed, since 8.1
>> > is not supported by pg_upgrade.
>>
>> Really? I've gotten apt based systems to run > 1 pg versions with
>> packages, but never rpm based. Especially not Centos or RHEL. Has
>> Fedora / yum started aachieved that?
>
> http://people.planetpostgresql.org/devrim/index.php?/archives/48-What-is-new-in-PostgreSQL-9.0-RPMs....
Dude, that is freaking awesome. And right after I converted all my
main db servers to Ubuntu. It was more about a late model kernel than
distros, and my choices were FC or Ubuntu for a late model kernel...
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: newer release branch
2010-10-06 15:03 newer release branch Marc Fromm <Marc.Fromm@wwu.edu>
@ 2010-10-07 00:34 ` Greg Smith <greg@2ndquadrant.com>
1 sibling, 0 replies; 7+ messages in thread
From: Greg Smith @ 2010-10-07 00:34 UTC (permalink / raw)
To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin
Marc Fromm wrote:
>
> There were no links or other helpful information provided. Has anyone
> upgraded from 8.1 to the latest version 9.0.1? Can you do it in one jump?
>
> Can it be done using yum on a RHEL server?
>
As of RHEL 5.5, there is now an official postgresql84 package you can
easily load. What I would do in your situation is target upgrading from
8.1 to 8.4 initially, via the dump/reload method, with the main expected
problem being the type case changes already mentioned. I've saved a
number of good links on this general topic onto
http://wiki.postgresql.org/wiki/Version_History that should provide some
additional guidance if you read through them a bit.
By the time you get that done, 9.0 should be a better tested and stable
release, and you can do a quick binary upgrade from 8.4 to 9.0 using the
pg_upgrade utility.
--
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance" Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2010-10-07 07:27 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-06 15:03 newer release branch Marc Fromm <Marc.Fromm@wwu.edu>
2010-10-06 15:57 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-10-06 20:28 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-06 22:02 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-10-07 04:43 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-10-07 07:27 ` Scott Marlowe <scott.marlowe@gmail.com>
2010-10-07 00:34 ` Greg Smith <greg@2ndquadrant.com>
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