On Mon, May 24, 2010 at 3:41 PM, Bruce Momjian <br...@momjian.us> wrote: > Robert Haas wrote: >> On Mon, May 24, 2010 at 3:11 PM, Bruce Momjian <br...@momjian.us> wrote: >> > Stefan Kaltenbrunner wrote: >> >> > I have updated the paragraph to be: >> >> > >> >> > ? ? Upgrading from PostgreSQL 8.3 has additional restrictions not >> >> > present >> >> > ? ? when upgrading from later PostgreSQL releases. ?For example, >> >> > ? ? pg_upgrade will not work for a migration from 8.3 if a user column >> >> > ? ? is defined as: >> >> > >> >> > Can you suggest other wording? >> >> >> >> hmm that seems better thanks, however I just noticed that we don't have >> >> a "general limitations" section. The way the docs are now done suggests >> >> that there are not limitations at all (except for the two warnings in >> >> the migration guide). Is pg_upgrade really up to the point where it can >> >> fully replace pg_dump & pg_restore independent of the loaded (contrib) >> >> or even third party modules(like postgis or custom datatypes etc)? >> > >> > Yea, that's about right. ?I can add limiations if you want. ?;-) >> >> I don't believe this. For one thing, I am pretty sure that if there >> are ABI differences between loadable modules between the old and new >> cluster, hilarity will ensue. > > Well, the point is that our existing code doesn't have any > incompatibilites that I know of. We could certainly add some in 9.1.
Yes, or third-party vendors could add some for us. We can't guarantee this in general. >> > The only open pg_upgrade items are the ones on our TODO list: >> > >> > ? ? ? ?http://wiki.postgresql.org/wiki/Todo >> > >> > (I can't give you a URL hash-reference to the section because it doesn't >> > work on Firefox and no one seems to be able to fix it.) >> >> It works OK for me. The link to /contrib/pg_upgrade within the nav >> section at the top righthand corner of the page seems to work just >> fine. >> >> http://wiki.postgresql.org/wiki/Todo#.2Fcontrib.2Fpg_upgrade > > The problem is that the "Contents" menu on the top right of the page > doesn't allow a clickable link to that section, and many others. It does for me... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers