Re: Create Index CONCURRENTLY Hangs Indefinitely.

On Tue, May 19, 2015 at 7:30 AM, Wei Shan <weishan(dot)ang(at)gmail(dot)com> wrote:

> 4. After it took more than 2hrs+, I went to terminate the session via
> Ctrl-C, it returned the following error.
>
> WARNING: canceling wait for synchronous replication due to user request
> DETAIL: The transaction has already committed locally, but might not have
> been replicated to the standby.
> ^CCancel request sent
> ERROR: canceling statement due to user request
>

The index has been created already, probably for a long time, but it was
waiting to be sent to your standby server. Seems that you have synchronous
replication configured and your standby is either delayed, not connected or
out of sync. That is bad, really bad, means that any writes to your primary
might be stalling now.

You should check your replication.

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres