RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin - Mailing list pgsql-general

From Hayato Kuroda (Fujitsu)
Subject RE: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin
Date
Msg-id OSCPR01MB14966052872EC78BE7E6C7FBBF54BA@OSCPR01MB14966.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: error “server process was terminated by signal 11: Segmentation fault” running pg_create_logical_replication_slot using pgoutput plugin  (abrahim abrahao <a_abrahao@yahoo.com.br>)
List 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


pgsql-general by date:

Previous
From: Steve Baldwin
Date:
Subject: Re: Lock timeout in commit
Next
From: Dominique Devienne
Date:
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)