Skip to content

no replication slot gets created by pglogical.create_subscription #495

Description

@jcasanov

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions