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@xxxxxxxxxxxxxx>
Attachment:
signature.asc
Description: This is a digitally signed message part
-- fedora-devel-list mailing list fedora-devel-list@xxxxxxxxxx http://www.redhat.com/mailman/listinfo/fedora-devel-list
