Re: Reindex concurrently

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Reindex concurrently
Дата
Msg-id CANzqJaCdfBXth+3R8nWRt1PHRzYKjkv=Mz9VJ7Jp6owur5fGJg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reindex concurrently  (SOzcn <selahattinozcnma@gmail.com>)
Ответы Re: Reindex concurrently  (SOzcn <selahattinozcnma@gmail.com>)
Список pgsql-admin
On Wed, Dec 13, 2023 at 12:28 PM SOzcn <selahattinozcnma@gmail.com> wrote:
Hello,

The result is when I run the function; "Reindex concurrently cannot run inside a transaction block. "

Of course, it works as follows, but in my building, I taken the scripts same like as follows but when I run this in function, I got the error message. 

REINDEX INDEX CONCURRENTLY "players_id_idx";

commit;

REINDEX INDEX CONCURRENTLY "players_about_idx";

commit;

According to my research, the only way to do this is to write a bash script in Linux and insert it with the loop. But since I want to manage this in the database system, I wanted to ask here.

What's wrong with a bash script run from cron?  (You should see my crontab; it's ginormous, running scripts against databases on 8 different servers.)

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

Предыдущее
От: SOzcn
Дата:
Сообщение: Re: Reindex concurrently
Следующее
От: SOzcn
Дата:
Сообщение: Re: Reindex concurrently