Thanks Hayato and Shlok, The Citus extension package is installed, but it is
not preload on shared_preload_libraries and citus extesion is not created.I
will create a new container without Citus extension package and adding stack
trace ( I think this is the one you're talking about) as soon as possible and I
will update here as soon I complete the test.
See information below.
show shared_preload_libraries;
shared_preload_libraries------------------------------- pg_stat_statements,
pg_repack(1 row)
\dx List of installed extensions
Name | Version | Schema |
Description--------------------+---------+------------+------------------------------------------------------------------------
btree_gist | 1.7 | public | support for indexing common
datatypes in GiST ltree | 1.2 | public | data type for
hierarchical tree-like structures pg_stat_statements | 1.10 | public |
track planning and execution statistics of all SQL statements executed pg_trgm
| 1.5 | public | text similarity measurement and index
searching based on trigrams pgcrypto | 1.3 | public |
cryptographic functions plpgsql | 1.0 | pg_catalog | PL/pgSQL
procedural language postgis | 3.5.1 | public | PostGIS
geometry and geography spatial types and functions uuid-ossp | 1.1
| public | generate universally unique identifiers (UUIDs)(8 rows)
Steps done until pg_create_logical_replication_slot command (just the steps,
does not include the full command)
set wal_level, max_replication_slots, max_wal_senders and listen_addresses
name | setting-----------------------+--------- listen_addresses
| * max_replication_slots | 10 max_wal_senders | 20 wal_level
| logical
Changed pg_hba filerestart databasepg_ctl restart -D $POSTGRESQL_DATA
create a user "CREATE USER user_rep WITH REPLICATION ENCRYPTED PASSWORD"ALTER
DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA myg GRANT SELECT ON TABLES TO
user_rep;CREATE PUBLICATION myg_pub FOR TABLES IN SCHEMA myg;ALTER PUBLICATION
myg_pub ADD TABLE myg
SELECT snapshot_name FROM pg_create_logical_replication_slot
On Wednesday, July 9, 2025 at 10:19:07 p.m. EDT, Hayato Kuroda (Fujitsu)
<kuroda.hay...@fujitsu.com> wrote:
Dear Shlok, Abrahim,
> Also, I was going to the logs on found:
> > > < 2025-07-08 14:57:08.653 UTC psql postgres postgres 172.18.0.94(53414)
> SELECT 00000 2025-07-08 14:57:07 UTC 1096 686d31c3.448 2025-07-08
> 14:57:08.653 UTC > LOG: Initializing CDC decoder
>
> This log is not present in Postgres source code. Why is this log appearing
> here?
I found the output in Citus source code [1]. So, I'm afraid that you may load
the
shared library provided by Citus when you created the replication slot.
If so, Citus community may be the better place to discuss the bug.
We can help if you can reproduce the bug by the PostgreSQL core codes.
[1]:
https://github.com/citusdata/citus/blob/5deaf9a61673e10c183b6d4f13593f168e1c2c10/src/backend/distributed/cdc/cdc_decoder.c#L85
Best regards,
Hayato Kuroda
FUJITSU LIMITED
