On 26.08.2017 15:10, Dmitry Lazurkin wrote:
> 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.
>
This is pg_proc.
inst/test/bin/oid2name -d user -f 11829
From database "user":
Filenode Table Name
----------------------
11829 pg_proc