Re: pg_upgrade bug found!

>     -- It will not lock any tables but will generate I/O.

add:
IMPORTANT: Depending on the size and configuration of your database,
this script may generate a lot of I/O and degrade database performance.
Users should execute this script during a low traffic period and watch
the database load.

>     --
>     CREATE TEMPORARY TABLE pg_upgrade_fix AS
>         SELECT 'VACUUM FREEZE pg_toast.' || c.relname || ';'
>         FROM     pg_class c, pg_namespace n
>         WHERE     c.relnamespace = n.oid AND
>             n.nspname = 'pg_toast' AND
>             c.relkind = 't'
>         ORDER by c.oid;
>     \copy pg_upgrade_fix TO 'pg_upgrade_tmp.sql';
>     \i pg_upgrade_tmp.sql
> 
> A fix will be included in upcoming Postgres releases 8.4.8 and 9.0.4.
> These releases will remove the need for the above script by correctly
> restoring all TOAST tables in the migrated databases.

add: However, users of databases which have been already migrated still
need to run the script, even if they upgrade to 9.0.4.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com