Thread: Logical replication blocking alter/drop

Logical replication blocking alter/drop

From

Mark Fletcher

Date:

13 December 2017, 04:36:51

Hi All,

Postgres 9.6.5. We run several logical replication processes off our main postgres server. What we've noticed is that schema changes seem to block until we halt the logical replication processes. For example, I just did a 'DROP INDEX CONCURRENTLY' command, and it just sat there until I stopped the logical replication processes (I did not have to drop the logical replication slots).

Is this expected or are we perhaps doing something wrong?

Thanks,

Mark

Re: Logical replication blocking alter/drop

From

Alvaro Herrera

Date:

14 December 2017, 16:38:37

Mark Fletcher wrote:
> Hi All,
> 
> Postgres 9.6.5. We run several logical replication processes off our main
> postgres server. What we've noticed is that schema changes seem to block
> until we halt the logical replication processes. For example, I just did a
> 'DROP INDEX CONCURRENTLY' command, and it just sat there until I stopped
> the logical replication processes (I did not have to drop the logical
> replication slots).

What sort of logical replication are you running?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services