Re: pg_upgrade 9.4 -> 9.5 with pg_trgm fails for me

On Fri, Jan 08, 2016 at 10:45:27AM -0500, Tom Lane wrote:

> Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> > [ pg_upgrade failed on pg_trgm ]
>
> Just for completeness, can you tell us which pg_trgm version (1.0
> or 1.1) is installed in the 9.4 database?

Sure:

    (pg_trgm,1.1,"text similarity measurement and index searching based on trigrams")

taken from:

                                   pg_available_extensions
    --------------------------------------------------------------------------------------
     (moddatetime,1.0,"functions for tracking last modification time")
     (pg_freespacemap,1.0,"examine the free space map (FSM)")
     (earthdistance,1.0,"calculate great-circle distances on the surface of the Earth")
     (test_shm_mq,1.0,"Test code for shared memory message queues")
     (tablefunc,1.0,"functions that manipulate whole tables, including crosstab")
     (uuid-ossp,1.0,"generate universally unique identifiers (UUIDs)")
     (pageinspect,1.2,"inspect the contents of database pages at a low level")
     (isn,1.0,"data types for international product numbering standards")
     (pgrowlocks,1.1,"show row-level locking information")
     (pgagent,3.4,"A PostgreSQL job scheduler")
     (tcn,1.0,"Triggered change notifications")
     (unaccent,1.0,"text search dictionary that removes accents")
     (pg_stat_statements,1.2,"track execution statistics of all SQL statements executed")
     (dblink,1.1,"connect to other PostgreSQL databases from within a database")
     (insert_username,1.0,"functions for tracking who changed a table")
     (fuzzystrmatch,1.0,"determine similarities and distance between strings")
     (pg_buffercache,1.0,"examine the shared buffer cache")
     (timetravel,1.0,"functions for implementing time travel")
     (cube,1.0,"data type for multidimensional cubes")
     (pg_trgm,1.1,"text similarity measurement and index searching based on trigrams")
     (dict_int,1.0,"text search dictionary template for integers")
     (xml2,1.0,"XPath querying and XSLT")
     (sslinfo,1.0,"information about SSL certificates")
     (btree_gin,1.0,"support for indexing common datatypes in GIN")
     (btree_gist,1.0,"support for indexing common datatypes in GiST")
     (tsearch2,1.0,"compatibility package for pre-8.3 text search functions")
     (test_parser,1.0,"example of a custom parser for full-text search")
     (seg,1.0,"data type for representing line segments or floating-point intervals")
     (citext,1.0,"data type for case-insensitive character strings")
     (intarray,1.0,"functions, operators, and index support for 1-D arrays of integers")
     (worker_spi,1.0,"Sample background worker")
     (file_fdw,1.0,"foreign-data wrapper for flat file access")
     (dict_xsyn,1.0,"text search dictionary template for extended synonym processing")
     (intagg,1.0,"integer aggregator and enumerator (obsolete)")
     (pgstattuple,1.2,"show tuple-level statistics")
     (autoinc,1.0,"functions for autoincrementing fields")
     (pg_prewarm,1.0,"prewarm relation data")
     (chkpass,1.0,"data type for auto-encrypted passwords")
     (pgcrypto,1.1,"cryptographic functions")
     (plpgsql,1.0,"PL/pgSQL procedural language")
     (postgres_fdw,1.0,"foreign-data wrapper for remote PostgreSQL servers")
     (adminpack,1.0,"administrative functions for PostgreSQL")
     (hstore,1.3,"data type for storing sets of (key, value) pairs")
     (ltree,1.0,"data type for hierarchical tree-like structures")
     (lo,1.0,"Large Object maintenance")
     (refint,1.0,"functions for implementing referential integrity (obsolete)")
    (46 Zeilen)

Diving into the postgresql-contrib-9.5 package shows that it
seems to install the same version (1.1, that is).

    4c5dc5fb5743dd4534cc0ad082c075d8  usr/share/postgresql/9.5/extension/pg_trgm--1.0--1.1.sql
    5222fd4cbbc5049b8e1bc64817443d7b  usr/share/postgresql/9.5/extension/pg_trgm--1.1.sql
    aceed02fc9730e6d34000869e6dfa308  usr/share/postgresql/9.5/extension/pg_trgm--unpackaged--1.0.sql
    f81af8d3825cb3a1762b9a27d0899b38  usr/share/postgresql/9.5/extension/pg_trgm.control

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346