[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Yum Upgrade Faq



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 davehollis com>

Attachment: signature.asc
Description: This is a digitally signed message part


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]