Logical replication blocking alter/drop

Started by Mark Fletcherover 8 years ago2 messagesgeneral

markf@corp.groups.io

over 8 years ago

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

Alvaro Herrera

alvherre@2ndquadrant.com

over 8 years ago

In reply to: Mark Fletcher (#1)

Re: Logical replication blocking alter/drop

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