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(dot)Hilbert(at)gmx(dot)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