I'm trying to migrate a Postgres database from 8.3 to 9.5. The database uses tsearch functionality.
The extensions tsearch2--1.0.sql and tsearch2--unpackaged--1.0.sql, found in /usr/share/postgresql/9.5/extension, have been loaded. This took care of most of the error messages when loading the database.
However 3 error messages persist: ERROR: function gin_extract_tsquery(pg_catalog.tsquery, internal, smallint) does not exist ERROR: function gtsquery_consistent(bigint, internal, integer) does not exist ERROR: function gtsvector_consistent(pg_catalog.gtsvector, internal, integer) does not exist
I'm struggling to find an answer how to resolve the error messages. Any assistance greatly appreciated.