Re: pg_create_logical_replication_slot in DB1 is blocked by a session in DB2

2022-05-26 Thread Kyotaro Horiguchi
At Wed, 25 May 2022 11:01:43 -0400, Fred Habash wrote in > I'm running this command while connected to pg cluster DB1: > > SELECT * FROM pg_create_logical_replication_slot('test_slot_99', > 'test_decoding'); > > When I examine pg_locks, I see the session is waiting on virtualxid and > blocked a

pg_create_logical_replication_slot in DB1 is blocked by a session in DB2

2022-05-25 Thread Fred Habash
I'm running this command while connected to pg cluster DB1: SELECT * FROM pg_create_logical_replication_slot('test_slot_99', 'test_decoding'); When I examine pg_locks, I see the session is waiting on virtualxid and blocked and blocking sessions are on two different DBs. After doing some research