Search Postgresql Archives

Re: Logical replication blocking alter/drop

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux