Can't start portgresql after F15 -> F16 upgrade

Lamar Owen lowen at
Thu Nov 17 19:20:47 UTC 2011

On Nov 17, 2011, at 2:08 PM, Michael Cronenworth wrote:
> PostgreSQL version upgrades have always had to be handled by data  
> dumps
> and 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 1813 bytes
Desc: not available
Url : 

More information about the users mailing list