Unable to Create or Drop Index Concurrently

Поиск
Список
Период
Сортировка
От Abdul Qoyyuum
Тема Unable to Create or Drop Index Concurrently
Дата
Msg-id CAA3DN=XSaPuxpGhznP_rNJz_AGdMFHeGXVvPt4TbwZsfrGD7fg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Unable to Create or Drop Index Concurrently  (Christophe Pettus <xof@thebuild.com>)
Re: Unable to Create or Drop Index Concurrently  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
Hi list,

We have a running Master-Slave High Availability set up. Naturally, we can't run any changes on read-only databases on slave, so we have to do it on the master node.

When trying to run the following command:
create index concurrently idx_cash_deposit_channel_id_batch_id on cash_deposit (channel_id, batch_id);

Waiting for a long time, and my connection dropped. When checking the table, we get the index as INVALID

Indexes:
    "pk_cash_deposit" PRIMARY KEY, btree (id)
    "idx_cash_deposit_channel_id_batch_id" btree (channel_id, batch_id) INVALID

And when dropping the invalid index, also takes a long time, my connection timed out, then when logging back in and check the table, it hasn't dropped.

Question is, do we have to shutdown traffic and close all existing open connections in order to drop and properly recreate the index? Any advice appreciated.

--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Setting up streaming replication on large database (20+ TB) for the first time
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Unable to Create or Drop Index Concurrently