Hello. I have database with installed pg_trgm extension with module path '/usr/lib/pg_trgm' (yes, this is mistake without $libdir (: ). Now I want upgrade postgresql to new major version. I keep old version 9.3 in /opt/postgresql/9.3 and new version 9.6 in /usr. Old version $libdir - /opt/postgresql/9.3/lib, new version $libdir - /usr/lib/postgresql. So now I am in trap because old version try to load shared libarry from '/usr/lib/pg_trgm'. So I want change '/usr/lib/pg_trgm' to '$libdir/pg_trgm' for old database. And I have only one ugly solution: replace '/usr/lib/pg_trgm' with '$libdir//pg_trgm' in table files (/usr/lib - 8 chars, $libdir/ - 8 chars).
May be someone has better solution? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
