sathiya psql wrote:
> Is there any article describing the migration database from postgresql 7.4to
> 8.1
The basic tips are:
1. Use pg_dump from 8.1 to dump your 7.4 database
2. Read the release notes for the intervening versions to see what might
affect your applications.
In particular, the UTF handling was tightened up which means some old
data might need to be tidied before import. Also add_missing_from was
turned to "off". But do read the release notes for 8.0 and 8.1 to see
what might affect you.
--
Richard Huxton
Archonet Ltd