Re: pg_migrator to /contrib in a later 9.0 beta - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_migrator to /contrib in a later 9.0 beta
Date
Msg-id 1273159858-sup-4530@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_migrator to /contrib in a later 9.0 beta  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_migrator to /contrib in a later 9.0 beta
List pgsql-hackers
Excerpts from Bruce Momjian's message of jue may 06 11:19:27 -0400 2010:

> It seems copying over pg_statistic would require preservation of
> pg_class.oid.  Right now we only preserve pg_class.relfilenode.

That could be fixed easily by creating a throwaway table which included the
qualified table name instead of the OID, and reloading it into pg_statistic
after the migration.

Perhaps this could be done as a regular task in the old database before
bringing the server down.
-- 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_migrator to /contrib in a later 9.0 beta
Next
From: Robert Haas
Date:
Subject: Re: max_standby_delay considered harmful