Ciao Silvio, On Tue, 13 Jul 2010 22:52:51 +0200, Iñigo Martinez Lasala > You should script database migration process in order to make it faster. > Upgrading binaries is really simple. A yum upgrade should be enough. Yes, faster and repeatable. Something you can launch with a script that does everything from scratch. As Iñigo was pointing out, you must pay a lot of attention in setting up a test environment which helps you: * simulate the migration process (and gives you accurate measures of times) * test the applications As Iñigo said, on a typical usage pattern, the most likely set of errors you will encounter are data type checks which require casting. Therefore it becomes crucial to: * setup the test database (preferably on a different server) * setup test applications that interface with the new Postgres database I assume you are using 8.3 because of RPM availability, isn't it? Otherwise, you should think of 8.4. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support Gabriele.Bartolini@xxxxxxxxxxxxxx - www.2ndQuadrant.it -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
