Lingering replication slots

From: Lou Tseng <ltseng(at)advancedpricing(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Lingering replication slots
Date: 2019-04-03 16:01:32
Message-ID: DM6PR11MB293905A4056E632A36C421EEC4570@DM6PR11MB2939.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

A newbie question: how do I delete lingering replication slots? When creating Subscription for logical replication, the CREATE SUBSCRIPTION stuck and didn't return. After ctrl-c and aborted the command, the master database have lingering replication slots that I can't delete because the active is true. Do I just kill the pid?

Thanks!

SELECT * FROM pg_replication_slots ;

slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn

--------------+----------+-----------+----------+----------------+-----------+--------+------------+------+--------------+--------------+---------------------

support_sub2 | pgoutput | logical | 28384483 | dragon_support | f | t | 29566 | | 96562907 | 5108/29C1610 |

support_sub | pgoutput | logical | 28384483 | dragon_support | f | t | 27253 | | 96562907 | 5108/2858880 |

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Marks 2019-04-03 16:13:22 Forcing index usage
Previous Message rihad 2019-04-03 15:42:03 Re: Recommendation to run vacuum FULL in parallel