Yum Upgrade Faq
David Hollis
dhollis at davehollis.com
Wed Jun 15 17:32:50 UTC 2005
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>
More information about the fedora-devel-list
mailing list