"David G. Johnston" <david.g.johns...@gmail.com> writes: > On Thu, May 7, 2015 at 4:19 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> pg_upgrade is okay in any case because it dumps and reloads the current >> extension's components. Doesn't matter whether there's another version >> that is not compatible.
> âFor clarity - which one is "current" in this context? > 1. The existing database's (previous extension version) > 2. The target database's (current default extension version in the new > PostgreSQL version) > âThe answer has to be #2 since the version in the existing database no > longer exists in the new PostgreSQL version. You're mistaken. pg_dump --binary_upgrade does not care whether the target database thinks that version exists or not. (It does care that there's a compatible shared-library object, but that's not at issue in this case.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers