Robert Haas wrote:
> I noticed in Bruce's talk that there are a number of post-migration
> steps which are currently partially manual. Ideally we'd like to
> automate them all, preferably in some sort of well-thought-out order.
> I actually suspect this is something like: analyze each database,
> reindex those indices invalidated by the upgrade, analyze each
> database again. Ideally we'd like to have some control over the
> degree of parallelism here too but that might be asking too much for
> 8.4.
I can easily have pg_migrator run those scripts itself but I pushed it
on to the administrator so pg_migrator could finish and they could
decide when to run those scripts. For example, there might only be
issues in a few databases and the other database could be used fully
while the upgrade scripts are running. The same hold for analyzing the
cluster --- anything I thought might take a while I gave to the
administrators.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +