On Nov 17, 2011, at 2:08 PM, Michael Cronenworth wrote:
PostgreSQL version upgrades have always had to be handled by data dumpsand data imports. With PostgreSQL 9.0 an upgrade utility was created, but it is not run by default as it is not considered stable. It works fine for me though. Perform a "yum install postgresql-upgrade" to install the utility and run "pg_upgrade" as root.
:-)That wasn't the first cut at pg_upgrade, but IMO it's the best cut at it so far.
What folks sometimes neglect to realize is how programmable the backend of PostgreSQL really is, and how that a full upgrade can involve recompiling or rebuilding functions inside the database (you can have user-written functions in C, Perl, Python, Tcl, and Ruby with Fedora-stock packages, for instance). That was always the hardest part of trying to upgrade PostgreSQL in a sane fashion.
And there is a postgresql-upgrade package in the repositories, but not, apparently, on the install DVD.
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
-- users mailing list users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
