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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
