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(a)davehollis.com>