I try investigate where PotsgreSQL keeps path of load libraries in catalog.
select version();
version
----------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit
select oid, datname from pg_database where datname = 'user';
oid | datname
-------+---------
16384 | user
$ grep --text --null-data '$libdir/pg_trgm' data/test/base/16384/*
data/test/base/16384/11829:set_limit!$libdir/pg_trgm ...
select relname, relfilenode from pg_class where relfilenode = 11829;
relname | relfilenode
---------+-------------
(0 rows)
Hmmm. Where is table with filenode 11829?
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
