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 |
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 |