Thread: BDR: remove junk replication identifier

Hi all,

I had many waste replication identifier (164 of 457), the env is BDR 0.9.3 and 9.4.4.

I'm going to remove those junk replication identifiers, but there is no exactly how to do in docs.

# select slot_name,plugin,datoid,restart_lsn from pg_replication_slots where slot_name like '%654018%';

# select * from pg_replication_identifier where riname like '%654018%';

# select * from pg_replication_identifier_progress where external_id like '%654018%';

From those 3 queries, summarize the slot, and identifier:

Validate number of the junk identifier, is it tally?:

# select count(*) from pg_replication_slots;

 count

-------

   293

(1 row)

# select count(*) from pg_replication_identifier;

 count

-------

   457

(1 row)

Identify the junk identifiers with the following query:

# select count(*) from pg_replication_identifier where riname not in (

# select split_part(slot_name,'_',1)||'_'||split_part(slot_name,'_',3)||'_'||split_part(slot_name,'_',4)||'_'||split_part(slot_name,'_',5)||'_'||split_part(slot_name,'_',2)||'_' as aaa from pg_replication_slots

# );

 count

-------

   164

(1 row)

457-293 = 164, seems exactly match...

Luckily this query return 6 rows, which I'm not understand :(

# select * from pg_replication_identifier_progress where external_id not in (

select split_part(slot_name,'_',1)||'_'||split_part(slot_name,'_',3)||'_'||split_part(slot_name,'_',4)||'_'||split_part(slot_name,'_',5)||'_'||split_part(slot_name,'_',2)||'_' as aaa from pg_replication_slots

);

 local_id |               external_id                | remote_lsn |   local_lsn

my question is:

Is it OK to remove those 164 junk identifiers? or are they any other approach?