On 26.08.2017 22:05, Tom Lane wrote:
> Dmitry Lazurkin writes:
>> Thanks. Can I update "pg_proc.probin" without any problems?
> Should work. I'd experiment in a scratch database before doing
> it in production, but I can't think of a problem offhand.
>
>
Dmitry Lazurkin writes:
> Thanks. Can I update "pg_proc.probin" without any problems?
Should work. I'd experiment in a scratch database before doing
it in production, but I can't think of a problem offhand.
regards, tom lane
--
Sent via
On 26.08.2017 18:24, Tom Lane wrote:
> You need to use pg_relation_filenode():
>
> regression=# select relname, pg_relation_filenode(oid) from pg_class where
> relname like 'pg_proc%';
> relname | pg_relation_filenode
>
Dmitry Lazurkin writes:
> select relname, relfilenode from pg_class where relfilenode = 11829;
> relname | relfilenode
> -+-
> (0 rows)
> Hmmm. Where is table with filenode 11829?
pg_class.relfilenode doesn't contain useful data for pg_proc and some other
On 26.08.2017 15:10, Dmitry Lazurkin wrote:
> I try investigate where PotsgreSQL keeps path of load libraries in catalog.
>
> select version();
>version
>
I try investigate where PotsgreSQL keeps path of load libraries in catalog.
select version();
version
--
PostgreSQL 9.3.4 on
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 -