Re: Reindex concurrently

On Wed, Dec 13, 2023 at 12:28 PM SOzcn <selahattinozcnma(at)gmail(dot)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.)