-
Notifications
You must be signed in to change notification settings - Fork 174
Open
Description
I have been using pglogical for long time with pg12 but now that we moved to pg16 things are starting to fail :(
provider=# select version(), pglogical.pglogical_version();
version | pglogical_version
-----------------------------------------------------------------------------------------------------------------------------------+-------------------
PostgreSQL 16.6 (Ubuntu 16.6-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit | 2.4.5
(1 fila)
subscriber=# select version(), pglogical.pglogical_version();
version | pglogical_version
-----------------------------------------------------------------------------------------------------------------------------------+-------------------
PostgreSQL 16.6 (Ubuntu 16.6-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.2) 9.4.0, 64-bit | 2.4.5
(1 row)
The replication set on the provider has been successfully used on other subscribers without any problem.
subscriber=# select pglogical.create_subscription('sub_shared_tables_hub_30_mam10', 'host=192.168.112.30 port=5433 dbname=elipsys_cresio user=replogical password=RepRov01017F connect_timeout=10', '{set_elipsys_cresio_shared_tables}', false, false, '{all}');
create_subscription
---------------------
1371532763
(1 row)
mam10=# select * from pglogical.local_sync_status ;
sync_kind | sync_subid | sync_nspname | sync_relname | sync_status | sync_statuslsn
-----------+------------+--------------+--------------+-------------+----------------
i | 1371532763 | | | i | 0/0
(1 row)
The subscription gets created but keeps in initialize state, no replication slot created on the provider and no replication origins on the subscriber either. Anything I can do to help to debug this?
Metadata
Metadata
Assignees
Labels
No labels