Yum Upgrade Faq

[David Hollis]

On Wed, 2005-06-15 at 18:20 +0300, Oskari Saarenmaa wrote:

> 
> Note that you will have to manually update the *.conf files in
> /var/lib/pgsql/data as the old version's configuration files are not
> neccessarily compatible with the new version.  I am not sure if 7.4 config
> files can be used with 8.0, but at least version 7.3's configs weren't
> usable in a 7.4 installation.
> 
> Also some of the SQL in your table defaults or custom functions might have
> changed its meaning, so you should check your upgraded database to make sure
> that things are as expected.  For example in 7.3 or 7.4 update the meaning
> of 'now' as a column default changed to mean now() at the table creation
> time instead of row creation time, and the fix was to default to now()
> instead of 'now'.
> 
> So I don't think there really is a totally safe way to upgrade a PostgreSQL
> installation, and I guess that's why the RPM doesn't do it automatically.
> 


This is pretty good stuff and should probably be included on the Wiki.
I can only imagine how many folks are going to be bitten by the PG
upgrade.  

-- 
David Hollis <dhollis at davehollis.com>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://listman.redhat.com/archives/fedora-devel-list/attachments/20050615/6a98cb47/attachment.sig>