On Fri, Jan 08, 2016 at 10:45:27AM -0500, Tom Lane wrote: > Karsten Hilbert <Karsten.Hilbert@xxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
