From: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
---|---|
To: | 'abrahim abrahao' <a_abrahao(at)yahoo(dot)com(dot)br> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, 'Shlok Kyal' <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
Subject: | RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin |
Date: | 2025-07-11 02:09:41 |
Message-ID: | OSCPR01MB14966052872EC78BE7E6C7FBBF54BA@OSCPR01MB14966.jpnprd01.prod.outlook.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Abrahim
> The Citus extension package is installed, but it is not preload on shared_preload_libraries
> and citus extesion is not created.
It is possible that a shared library is loaded even if shared_preload is not set
and CREATE EXTENSION is not executed. Per my understanding the specified plugin
name would be searched by the same rule as other libraries. See [1].
Another example is 'test_decoding'. It is a sample plugin which postgres-core
includes. Anyone can use the plugin via SQL function. CREATE EXTENSION is not needed.
```
postgres=# SELECT pg_create_logical_replication_slot('slot', 'test_decoding');
pg_create_logical_replication_slot
------------------------------------
(slot,0/1829CE0)
(1 row)
```
> I will create a new container without Citus extension package ...
Yeah, it is quite helpful to understand the issue correctly. Thanks for working on it.
[1]: https://www.postgresql.org/docs/devel/xfunc-c.html#XFUNC-C-DYNLOAD
Best regards,
Hayato Kuroda
FUJITSU LIMITED
From | Date | Subject | |
---|---|---|---|
Next Message | Dominique Devienne | 2025-07-11 08:49:20 | Re: Aggregate versions of hashing functions (md5, sha1, etc...) |
Previous Message | Steve Baldwin | 2025-07-10 20:32:45 | Re: Lock timeout in commit |